Alex Debugs!

Mysql "Select" Output Turned Arround

2012/08/19 — alex — cli linux-2 mysql sql syntax CLI linux

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.