Jump to content


show innodb status with "\g" does not work

  • Please log in to reply
1 reply to this topic

#1 sqletom



  • Members
  • Pip
  • 2 posts

Posted 24 March 2005 - 04:21 PM

When I run "SHOW INNODB STATUS" it works but to get the results set in a better format I added the /G and the following error is returned:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\G' at line 1
(0 ms taken)

/*just to clarify:*/
SHOW INNODB STATUS /* does work */

SHOW INNODB STATUS\G /* does not work */

Am I doing something wrong?

#2 Ritesh


    Advanced Member

  • Members
  • PipPipPip
  • 2,539 posts

Posted 24 March 2005 - 04:25 PM

\G is a special command supported by the MySQL command line utility.

Its not a valid SQL statement and thus the error.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users