MySQL Vertical Output

To see results structured vertically in the mysql console use \G instead of ;

mysql> select * from users \G
*************************** 1. row ***************************
id: 1
email: user1@somedomain.com
encrypted_password: asdf123
created_at: 2011-11-07 22:24:46
updated_at: 2011-11-07 22:24:46
roles_mask: 1
*************************** 2. row ***************************
id: 2
email: user2@somedomain.com
encrypted_password: asdf123
created_at: 2011-11-07 22:27:33
updated_at: 2011-11-07 22:28:18
roles_mask: 0