Binary Code

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