how to alter stored procedure in mysql

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