Today while doing some sql queries, i came across a issue where i wanted to see all the columns of a table,however there were lot of columns inside my table, which made it difficult to see all columns properly.
Thus i came out with this simple query where you can see all the query results vertically:
mysql> select * from table_name limit 1\G *************************** 1. row *************************** column1: value1 column2: value2 column3: value3 column4: value4 column5: value5 1 row in set (0.00 sec)
