Auto vertical output lands in MySQL 6.0.4

Have you ever executed a query from the MySQL command line client only to find that the output wrapped and the result is unreadable? In the past you have to run the query again with \G instead of ; or \g to get it to display the output in a vertical mode. My feature in MySQL 6.0.4 fixes that. The auto-vertical-output option tells the command line client to display the results in vertical format if the results are going to be too wide to display horizontally. It does this without re-executing the query because MySQL passes the length of each column in the result set. If the client isn’t able to determine the width of the screen it will default to 80 chars.

5 Comments

  1. [...] on April 21, 2008 Eric Bergen: Have you ever executed a query from the MySQL command line client only to find that the output [...]

  2. Justin Swanhart says:

    Awesome!

  3. Very nice, I’m considering setting this as default for my mysql clients.

    One small addition however – I’d prefer if the explicit ‘\g’ hint could override the automatic output choice and force the the tabular form anyway…

  4. Dabbler of SQL says:

    Running the mysql command line client with the -E switch will force it to display the vertical format in version 5. Not as cool, but handy for those of us who can’t wait/upgrade.

Leave a Reply