Subscribed unsubscribe Subscribe Subscribe

hasen's tech life

Twitter: @hasen

MySQLで問い合わせ結果を"\G"で整形する時に,文末に";"はいらない

# MySQLで問い合わせ結果を"\G"で整形する時に,文末に";"はいらない.

# wrong
> mysql> select count(*) from member\G;
> ************** 1. row **************
> count(*): 7
> 1 row in set (0.01 sec)
>
> ERROR:
> No query specified

# correct
> mysql> select count(*) from member\G
> ************** 1. row **************
> count(*): 7
> 1 row in set (0.00 sec)