Easily reviewing SELECT query results in a shell window can be particularly difficult when a table consists of numerous columns.
Remedying this inconvenience is easily done by appending the \G switch to the query:
mysql>SELECT * from users WHERE id=1\G
Executing this query with the \G switch attached formats the output like so:
mysql test>select * from users where id=1\G
*************************** 1. row *********
id: 1
name: iams
email: iams@example.com
city: BN
1 row in set (0.00 sec)
..
