Bug #5880 delimiter problem while entering procedure code
Submitted: 4 Oct 2004 14:19 Modified: 4 Oct 2004 14:32
Reporter: Gary Minnock Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: User-defined functions ( UDF ) Severity:S1 (Critical)
Version:4.0 OS:Windows (xp)
Assigned to: Dean Ellis CPU Architecture:Any

[4 Oct 2004 14:19] Gary Minnock 
Description:
Hi I am using mysql 4.0 which is fine.

i want to write a procedure.

The problem is that the mysql won't let me change the delimiter so that I can send it to the server.

the manual says you can do this

delimiter //

create procedure
.
.
.
..
end;

delimiter ;

I can't do this, its not even in the help command. Do I have the wrong version of mysql or is there another way of doing it?

G

How to repeat:
delimiter //
[4 Oct 2004 14:32] Dean Ellis 
Yes, you are trying to use MySQL 5.0 features.  4.0 does not have support for stored procedures and such, and the mysql client for that version does not understand the delimiter command.
[4 Oct 2004 15:37] Gary Minnock 
is mysql 5.0 stable and how do i transfer my database from mysql 4.0
[4 Oct 2004 15:46] Dean Ellis 
MySQL 5.0 is currently in alpha; you can download it for testing but it is under active development and does have bugs.  Check the manual and the download pages for more information.
[4 Oct 2004 15:52] Gary Minnock 
what would you recommend I do?
[4 Oct 2004 15:54] Gary Minnock 
I'm currently usinf mysql in a college project?  Is there another way of creating procedures in mysql 4.0?