3.03.2011

MySql tip for displaying query results vertically

I have a need at the day job to view mysql records via the mysql command line client.  Some of the tables I'm looking at have 100 to 200 columns so it's pretty annoying to view this data horizontally across the screen.  If you end your queries in the mysql command line client with \G instead of a semicolon, then it will display the results vertically down the page.  Try it out!

SELECT * FROM users WHERE id = 72 \G