MySQL Tips and Tricks

1.  TO DISPLAY ONLY PAGE WIDTH ON THE COMMAND LINE
mysql> pager less -SFX
mysql> SELECT * FROM sometable;
This will pipe the outut through the less command line tool which - with these parameters - will give you a tabular output that can be scrolled horizontally and vertically with the cursor keys.

Leave this view by hitting the q key, which will quit the less tool.