Eric Bergen: Have you ever executed a query from the MySQL command line client only to find that the output wrapped and the result is unreadable?
I have. A lot.
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.
I am standing up and cheering. No, really. I love those little things that make life (yes, I said life) easier:
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.
It's a shame MySQL 6 is still so far away, but still: nice feature!
True, but in a lot of the cases you're using limit anyway. And something like 'show slave status' always has just 1 'row'.
Meh, it's not that useful once you get 10 rows or more in a result. Then you'll have to edit your query anyway to limit it to something more usable at which point I'm perfectly fine with adding \G .