Last Updated: September 09, 2019
·
12.6K
· milesmatthias

MySQL Pretty Print

mySQL results can suck if your screen isn't wide enough to display everything. Here's the solution:

mysql> SELECT * FROM Table \G;

3 Responses
Add your response

Nice tip, thanks!

over 1 year ago ·

Also I like a lot mysql -t mydb < file | less -S

mysql -t : display output in table format

less -S : do not fold long lines

over 1 year ago ·

crazy how the simple things just seem to work

over 1 year ago ·