MySQL Forums
Forum List  »  Stored Procedures

Re: Create Stored Procedure Issues with PhpMyAdmin
Posted by: Arian Fornaris
Date: November 19, 2007 05:52PM

Hey people, you need to set DELIMITER=;; and separate create-procedure-statements by ;;

Example:

-- create procedures
delimiter ;;
create procedure hello()
begin
select 'hello';
end;;
create procedure goodby()
begin
select 'good by';
end;;
delimiter ;
-- other querys
...

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.