When you work on mysql server and hit some command in mysql prompt,you get the output in horizontal way.
For eg. I hit the command, select emailid from linuxtable where user = ‘sharad’; and this table has lots of fields . In that case the output looks weird.
Rather than seeing the output Horizontally in mysql you can also see the output Vertically.
For seeing vertically you have to suffix this switch ( G ) at the end of command
Lets see the example:
mysql> show table status where Name = 'tutorials_tbl' G; *************************** 1. row *************************** Name: tutorials_tbl Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: 2 Create_time: 2013-08-10 16:16:13 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) ERROR: No query specified mysql>
If you do not use G ,this is how it looks, below is the sample of it