Being a terminal fan myself, I usually find myself running
queries in the mysql client instead of a UI interface as it is
much faster. You get to see the results instantaneously.
One thing which is pretty tedious is editing a big query again after once running it as the whole multi-line formatted query now appears on a single line, thus reducing its readability.
But no problems, you can edit your query from a file and run the file from your mysql client terminal as many times as you want with as many edits.
To do so, follow the below steps:
1. Open your terminal and cd into the …