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.
You can use the \G
command (instead of the ;
) at the end of your SQL queries...
Example:
SELECT * FROM USER \G
It will display your table in row form instead of column form.