Re: Create Stored Procedure Issues with PhpMyAdmin
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
...
Subject
Views
Written By
Posted
44302
November 13, 2006 09:44AM
16209
November 13, 2006 07:25PM
13298
November 15, 2006 10:35AM
Re: Create Stored Procedure Issues with PhpMyAdmin
12851
November 19, 2007 05:52PM
10380
November 20, 2007 10:27AM
8782
June 09, 2008 08:32AM
9132
November 24, 2007 11:00PM
8498
November 22, 2007 03:21AM
8211
November 22, 2007 03:24AM
7619
March 20, 2008 08:55AM
5747
August 05, 2008 10:19PM
5602
August 06, 2008 07:25AM
9728
February 13, 2009 12:49PM
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.