how to alter stored procedure in mysql

Posted by Shanky11 under Others on 8/25/2012 | Points: 10 | Views : 2395 | Status : [Member] | Replies : 1
how to alter stored procedure in mysql
create PROCEDURE detail
(
IN id int,
OUT sname varchar(50)
)
BEGIN
select name into sname FROM student where sid=id;
END




Responses

Posted by: Maheshvishnu on: 8/31/2012 [Member] Starter | Points: 25

Up
0
Down
MySQL provides an ALTER PROCEDURE statement to modify a routine, but only allows for the ability to change certain characteristics. If you need to alter the body or the parameters, you must drop and recreate the procedure.

eg:drop procedure if exists detail;


and recreate the procedure as you want

mahesh

Shanky11, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response