Secrets of the MySQL Client Command Line

“Graphically oriented MySQL administration tools abound, but for
true speed and no-frills management perhaps nothing is more
effective than the command-line driven MySQL client. However, the
inordinate amount of typing due to executing common queries,
determining what database you’re currently logged into, and
monitoring database server performance quickly can become tedious.
In this article, I’ll unveil a few of MySQL’s command-line hidden
features that can eliminate those extra keystrokes and along the
way make you

“If I had a dollar for every time I ran show tables just as a
reminder of which database was currently selected, I’d be writing
this article from an exotic beach locale. The fact is, when
regularly jumping among an IDE, shell prompt, and MySQL client
prompt it can be very easy to forget your spot…”

Complete
Story