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
Shanky11, if this helps please login to Mark As Answer. |
Reply | Alert Moderator