How can I format the mysql prompt output?

Question

The mysql prompt spits out column data in a messy format, is there a way to format it?

Answer 1

You can get vertical output using mysql> select * from table \G.