MySQL ego display
Using \G
and the end of a mysql command outputs the results as a vertical display. Good for selects that have a lot of columns but few rows.
SELECT * FROM partytime WHERE party = 1 \G;
Written by Erin Marchak
Related protips
1 Response
You actually don't need the semi-colon in the end. In fact, that is interpreted as a second empty query because \G terminates the first query.
over 1 year ago
·
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#