18 Aug 2008, 1:49pm
/dev/random
by

1 comment

The Most Powerful MySQL Debugging Tool: \G

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).

 
←    →