Better Output for MySQL Select Command Using \G

If you ever find yourself using MySQL via command line and end up with something like this:

mysql-command-line And thought there must be another way, well here it is: Use \G instead of ; at the end of your select command.

For example:

select * from CHARACTER_SETS\G

Below is an image of the output from this select:

mysql-nice-output

Happy Querying!

 

Leave a Reply

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