XCeptable XCeptable - 1 year ago 98
MySQL Question

How to adjust display settings of mysql command line?

Command Line of mysql is not displaying results properly. I mean some columns of table are in 1st line some in 2nd line. Output is also broken into two rows. How do I adjust these settings so that it properly display results.

Answer Source

You can use the \G command (instead of the ;) at the end of your SQL queries...



It will display your table in row form instead of column form.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download