Hopefully something here will be useful

Making mysql output more readable

When using the mysql CLI to perform queries on tables with many attributes the resulting output is often unreadable because of all the line wrapping. Here's a tip. Instead of terminating the query with a semicolon, terminate it with \G (case-sensitive). This will display your results vertically which is often MUCH more readable when dealing with results with many attributes. In my specific instance I was trying to display the replication status on a slave. By using "show slave status\G" instead of "show slave status;" the output was much easier to read.

---