Quick Tip: Display MySQL Results Vertically

When I'm working on a remote server it's sometimes useful to get data out of mysql using the command line mysql client (don't EVERY install phpMyAdmin on a public server) but it's hard to read data from tables that have lots of columns.

Normally, you end up with something like this when you terminate your command with a semicolon (;):

SELECT * FROM User WHERE id = 13;

But if you terminate your command with a \G you end up with the same data in a much more readable format:

SELECT * FROM location_cities\G