Hi,
I am looking to migrate an Informix database to MySQL and trying to
write a simple stored procedure in MySQL 5.0.3. I referred to few
examples posted and used the statements from them but i get errors while
creating this procedure.
CREATE PROCEDURE sp_test
(
IN user_idinteger,
Dinesh,
Do you have something like
DELIMITER |
before the CREATE PROCEDURE call, and
|
DELIMITER ;
after it?
Peter Brawley
http://www.artfulsoftware.com
-
Anchan, Dinesh wrote:
Hi,
I am looking to migrate an Informix database to MySQL and trying to
write a simple stored
but i will get there.
Thanks for your help.
Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Friday, April 01, 2005 12:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help with Stored Procedures iin MySQL 5.0.3-beta
Dinesh,
Do
]]
Sent: Friday, April 01, 2005 12:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help with Stored Procedures iin MySQL
5.0.3-beta
Dinesh,
Do you have something like
DELIMITER |
before the CREATE PROCEDURE call, and
|
DELIMITER ;
after it?
Peter Brawley
http