Last Updated: December 26, 2018
·
1.75K
· emarchak

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;

1 Response
Add your 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 ·