I can’t seem to find the syntax for editing an already-created stored procedure in MySQL.
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
You can change certain attributes using the ALTER PROCEDURE syntax
To change the procedure body you will have to drop and recreate the entire procedure, in this case SHOW CREATE PROCEDURE may be useful
Mysql do not allow to alter stored procedure but SP can be drop and recreate SP options are available in Mysql like below query
DROP PROCEDURE IF EXISTS foo; delimiter // create PROCEDURE foo (args) begin bla bla end// delimiter ;