MYSQL: select with many fields

When you make select * from table where many columns in CLI than you see ugly output

Solution:
change ; to \G in your query and you receive list of pairs (column: value)

Example:

mysql> select * from user \G

or set another pager by next command:

mysql> pager less -n -i -S

Comments