I'm getting a MySQL 1064 error for the simplest query when run with \G
at the end. This works:
select * from locations;
and this doesn't:
select * from locations\G
hmmm… is there any way to see what the proper vertical representation is?
MySQLmysql-workbench
I'm getting a MySQL 1064 error for the simplest query when run with \G
at the end. This works:
select * from locations;
and this doesn't:
select * from locations\G
hmmm… is there any way to see what the proper vertical representation is?
Best Answer
\G
is a delimiter exclusive to the mysql clientI personally do not use MySQL Workbench, but many others have done the following
Mar 12, 2010
: How to get a table creation script in MySQL Workbench?Mar 28, 2012
: \G like vertical output in MySQL Workbench for show engine innodb statusBut here is the Blog for MySQL Workbench Team ( MySQL Workbench: Vertical Query Output )
Give Them a Try !!!