MYSQL: select with many fields

Post date: Jun 14, 2011 12:28:42 PM

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