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 folder you want to
store our sample mysql file. Then save your query in a sample
file called my_query.sql
$ cd /path/to/folder
$ vim my_query.sql
Save a sample query like:
SELECT * FROM employees
WHERE type LIKE …
Showing entries 1 to 2
Jun
12
2014
Mar
13
2011
If you use a Mac, and you are dealing with many similar tasks at
once, like examining many database servers in different
terminals, you may like this one.
I have been using iTerm
2 for a while, and my handling of parallel tasks has improved
a lot. (No, I am not talking about Parallel replication, although I have applied
this trick while testing that technology as well.)
iTerm2 has some cool features, and probably the most striking one
is split panes. That alone would be a good reason
for giving iTerm2 a try. But the one that I use the most, often
in combination with Split Panes, is called Send Input to all
tabs.
Here is how it works.
Let's say I need to …
Showing entries 1 to 2