Last Updated: February 25, 2016
·
8.212K
· code_arts

MySQL: Displaying Query Results Vertically

Many times, you have a small terminal screen and you are in a mysql prompt where paginating is hard to do and your query outputs are hard to read.

You can output query results vertically instead of a table format. Just type \G instead of a ; when you end you queries in mysql prompt.

http://dev.mysql.com/doc/refman/5.0/en/mysql-tips.html#vertical-query-results