Archive for the 'MySQL' Category

How do I view MySQL query results in command line

Jul 28 2012 Published by under all,MySQL

SELECT * FROM table WHERE 1 = 1 \G;

The \G option will print results vertically so they are readable.

No responses yet

How do I find a column’s datatype in MySQL command line?

Jul 23 2012 Published by under MySQL

No responses yet