Format query output at mysql prompt?
I'm just wondering if there's a way to print out the results from a query conducted at the mysql prompt so that it's a little easier to read.
field a | field b | field c
| 100 | abcedef | ghijklmnop
is there a way to print to screen so that it looks like this:
field a | 100
field b | abcedef
field c | ghijklmnop
Not sure it's any easier to read but try terminating with a \G instead of a ; for that type of display
Originally Posted by takeiteasyonme
November 26th, 2012, 12:58 PM
MySQL query ouput can be formatted in better way using \P less -S option as below:
mysql> \P less -S
mysql> <SELECT QUERY>
December 4th, 2012, 01:02 PM
Thanks in advance for any suggestions!