5 MySQL tricks you may not know

It’s easy to be comfortable using a few well-worn SQL query techniques, but MySQL is deep – way deep. Here are 5 tricks you may find useful.
1. Produce terminal-friendly output
Occasionally you may be using the command line and find yourself limited by the size of either the table you’re getting results from or by the size of the terminal window you’re using. (I find the DPS window particularly resistant to resizing…

Visit Source Article …