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!