Bug #22686 Creating Stored Procedure
Submitted: 25 Sep 2006 21:35 Modified: 26 Sep 2006 9:05
Reporter: Brian Bell Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.3 OS:Windows (Windows XP pro)
Assigned to: CPU Architecture:Any

[25 Sep 2006 21:35] Brian Bell 
Description:
When using the Query Browser (v1.2.3) and trying to create a Stored Procedure.  

I get an error.  

However, if I use the command language with "source", it works fine.

How to repeat:
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`spRICHgetcardtype` $$
CREATE PROCEDURE `spcardtype`()
BEGIN
  SELECT cardtypeid,cardtypedescr,programtype FROM cardtype;
END $$

Script line: 1	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 'END $$

------------------------------------------------------------------' at line 1

Suggested fix:
Use command line.
[26 Sep 2006 9:05] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicates bug #22324