Create Stored Procedure in PHPMyAdmin

August 20, 2009 at 12:41 pm (MYSQL)

Creating stored procedure in the phpmyadmin is little bit different as we are creating using mysql IDE.

This is the method how we can create a stored procedure in PHPMYADMIN also,

delimiter ;;
drop procedure if exists test2;;
create procedure test2()
begin
select ‘Hello World’;
end
;;

By executing this will get successful new stored procedure created in your database as we are doing with SQLYOG or some IDE.

About these ads