Software Dev

MySQL Vertical Listing

Quick tip…

If you use the MySQL command line, you may get annoyed when you have lots of columns and they wrap, making the data nearly impossible to read.

Image result for MySQL \g

I used to carefully craft my select clause to get just the right data, but this is easier. Just add \G onto the end of the query.

πŸ‘‰ The \G modifier in the MySQL command line client

It lists all the data vertically, so wrapping is not a problem. πŸ€“

Image result for MySQL \g