MySQL CLI Output Formatting Tips

I’m sure you’ve seen results similar to this on a standard query:

Now, if you use the G option (Send command to mysql server, display result vertically.):

That makes reading the output from command line really nice.

One more tidbit that I’ve found I like to do is use the p option (Print current command.) combined with G for reference:

Got any other tips?  Leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *