Jenny
Jan 8, 2008 3:57:41 PM

can't run "Delimiter" statement for MYSQL

I run the following query in WINSQL for a mysql database: delimiter / and get this error: Error: 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 'delimiter /' at line 1 (State:37000, Native Code: 428) But this statement supposes to be a valid statement in mysql. What can I do in order to make it work?


Synametrics support engineer
Jan 12, 2008 3:47:06 PM

can't run

Dear Jenny, The "Delimiter" command is not part of MySQL grammar - it is a way to specify a statement delimiter in the "mysql" client program. The equivalent of a delimiter in WinSQL is called "Query Terminator", which by default is set to the word "go". This allows you to write queries like: select * from table1 go select * from table2 If you like to change the value for query terminator, you can do that by clicking "Edit/Options". Please refer to http://kb.synametrics.com/FrontController?operation=1&id=42 for more information about it. Let us know if you have any other question. Best regards, Synametrics Support. >I run the following query in WINSQL for a mysql database: > >delimiter / > >and get this error: > >Error: 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 'delimiter /' at line 1 >(State:37000, Native Code: 428) > >But this statement supposes to be a valid statement in mysql. What can I do in order >to make it work?

Navigation

Social Media

Powered by 10MinutesWeb.com