The Most Powerful MySQL Debugging Tool: \G
By chris on August 18th 2008 in /dev/random | 388 views
I used MySQL for years and years before coming across this little MySQL output-formatting tip that makes all the difference in the world when viewing your raw data. Instead of:
SELECT * FROM users;
use:
SELECT * FROM users\G
The result is very nicely formatted output (almost YAML-like, save for the spacing) that’s much, much easier to read (at least for those of us on small, 17″ laptops instead of the mega 30″ monitors).
