blog.onlysimpler.com

Ever used the mysql command line client only to end up with horribly formatted output like this:

mysql> select * from users;
+----+-----------------------+------------+-----------+-------------------------
-----------------+
| id | email                 | first_name | last_name | password
                 |
+----+-----------------------+------------+-----------+-------------------------
-----------------+
|  6 | shane@onlysimpler.com | Shane      | Bell      | 5baa61e4c9b93f3f0682250b
6cf8331b7ee68fd8 |
+----+-----------------------+------------+-----------+-------------------------
-----------------+
1 row in set (0.11 sec)

Try sticking a \G on the end to get this instead:

mysql> select * from users G
*************************** 1. row ***************************
        id: 6
     email: shane@onlysimpler.com
first_name: Shane
 last_name: Bell
  password: 5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8
1 row in set (0.00 sec)

Much easier to read :)