How do you edit a stored procedure in MySQL?

I can’t seem to find the syntax for editing an already-created stored procedure in MySQL.

Contents hide

Answers:

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.

Method 1

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

Method 2

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 ;

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes

Article Rating