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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.