how to alter stored procedure in mysql

Posted by Shanky11 under Others on 8/25/2012 | Points: 10 | Views : 3557 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...