MySQL Pretty Print in Command Line

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

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

mysql> pager less -SFX
mysql> SELECT * FROM sometable;

So an ugly output like this:

Was transformed into a nice looking output like this:

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;