MySQL Pretty Print in Command Line

MySQL Pretty Print in Command Line

April 23, 2014
Tools

TLDR; Use \G at the end of your query, as in mysql> SELECT * FROM sometable\G;

Using pager

I was looking for a better way to output mysql tables in console, and came across the following gem:

mysql> pager less -SFX<br /> mysql> SELECT * FROM sometable;

So an ugly output like this:

Was transformed into a nice looking output like this:

Using \G

Another option is to add \G at the end of your command. This will change the output just for that command, without changing the default output.

mysql> SELECT * FROM sometable\G;