Menu
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.
796
Open the Command Prompt and press Alt + ↵ Enter to make it full-screen. Press the keys again to switch it back.
Once you get in mysql just press ctrl + L and you will clear the screen.
Just right-click on the title bar, select defaults you will get access to do everything in terms of color, font & background. Restart the command line to see the changes.
Show MySQL Tables from the Command Line To get information about the tables from the Linux shell, you can use either the mysql -e command or the mysqlshow command that displays databases and tables information. This is especially usefully when you want to work with your MySQL databases using shell scripts.
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.
182
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
