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