Mysql “Select” Output Turned Arround

When you have a mysql table with lot’s of attributes, it’s hard to read the output of a statement like this in mysql:

select * from table limit 1;

The data is folded very ugly.

Easy Solution:

select * from table limit 1 \G

Mysql is showing one “Fieldname: Value” per line.

 

Share on Facebook0Tweet about this on TwitterShare on Google+0Email this to someone