Create Stored Procedure in PHPMyAdmin

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.

Advertisements

4 Comments

  1. Atmey said,

    October 22, 2009 at 9:22 am

    Great thanks, been searching for a while. I found some other commands that might be helpful:

    call it
    call test2()

    view all procedures
    select * from information_schema.routines

    works in phpmyadmin but can’t process output from calling it.

  2. pradeep said,

    September 4, 2010 at 8:58 am

    how to call procedure in phpmyadmin

    i make a procedure
    eg display()
    witout argu or parameter
    and call display but not work proper

  3. vinay mishra said,

    September 22, 2010 at 12:37 pm

    Hi thanks this is good it is working.

  4. Noel said,

    November 17, 2010 at 11:31 pm

    Thank you – just tested this in v2.11.10.1 (with multiple statements in the same procedure) and everything works great.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: