How can I format mysql output?

Question

The mysql query subtracts the column data in a messy format, is there any way to format it?

Answer 1

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