In the case of programming language, you can squeeze it out of the notepad and run it in the shell.
I know that you use IDE like Eclipse.
I don't think SQL will enter multiple lines of queries in the command line either.
I wonder how you use it in practice.
Where do you organize the query, how do you save it, and where do you run it?
I would appreciate it if you could tell me how to use these things.
(If there is a way to recommend it for practice, please recommend it too.)
sql
I use tools called datagrip, sqldeveloper for simple queries.
Datagrip supports most of the divisions (oracle, mysql, postgresql, msql, etc.), so it's good to manage multiple types of divs in one tool. If you use a tool, it's good to assist when writing queries, so usually you write queries in the tool, and if you write a large number of repeated queries, you use sublime text or atom, but I think sublime text is faster than atom.
I use Postgresql. I use a SQL client called Postico. When you need to make a long query, write it in sublime text and use it.
Other developers record a lot of queries in Evernote.
© 2024 OneMinuteCode. All rights reserved.