1 Blog Entry tagged: mysql
MySQL tip
I've been studying recently for the MySQL certification test and have discovered a few tricks along the way. One of my favorites is the combination of using pager and vertical output.
To set your pager to use less:
mysql> pager less
PAGER set to less
Now when you perform a select which returns more rows than rows on your screen, the pager will allow you to paginate through the results.
To get MySQL to display results vertically instead of in columns horizontally, end your SQL with "G" instead of with the semicolon (or "g")...
mysql> SELECT * FROM mails WHERE ...