Total Pageviews

Monday, June 6, 2011

How to view all stored procedures in phpmyadmin

To create a procedure write followong command

delimiter ;;
drop procedure if exists mishraa;;
create procedure mishraa()
begin
select ‘Ashutosh Mishra’;
end
;;

to view the stored procedure, run the below commands
SELECT *
FROM information_schema.routines

above query will fetch all the stored procedures in your MYSQL database

No comments:

Post a Comment