Bug #10955 Delimiter not recognized
Submitted: 30 May 2005 10:35 Modified: 3 Jun 2005 15:03
Reporter: [ name withheld ] (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.9 OS:Windows (WinXP sp2)
Assigned to: CPU Architecture:Any

[30 May 2005 10:35] [ name withheld ]
Description:
If I open a terminal, connect to MySQL and issue the following:

...
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 5.0.4-beta-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> delimiter //
mysql> use test//
Database changed
mysql> select now()//
+---------------------+
| now()               |
+---------------------+
| 2005-05-30 12:33:49 |
+---------------------+
1 row in set (0.00 sec)

mysql>

everything goes fine, if I issue a "delimiter //" in MySQL Query Browser i get an:

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

This makes Query Browser unsuitable for writing stored procedures.

How to repeat:
Issue a "delimiter //" in MySQL Query Browser and get an:

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
[30 May 2005 11:49] MySQL Verification Team
Duplicate of:

http://bugs.mysql.com/bug.php?id=9428

Bug #9428  	MySQL Query Browser does not accept DELIMITER statement
[30 May 2005 12:11] [ name withheld ]
Please, this bug can't be marked as Duplicate as the Bug #9428  is considered closed!!!!
If the problem has surfaced again you should consider reopening that one or keeping this open.
[3 Jun 2005 15:03] Michael G. Zinner
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Please note that a script like this

delimiter //
use test//
select now()//
delimiter;

can only be executed in the script editor (Ctrl+Shift+T). You cannot execute this in the query area. In the query area you do not need any delimiter at all. you just put in the statement.

SELECT * FROM categories c

You can also use 

SELECT * FROM categories c;

but it is not necessary. And you cannot change ; in that case.