如何修改存储过程 mysql_如何在mysql中更改存储过程

如果您的意思是要编辑过程,那么您不能根据MySQL文档：

This statement can be used to change the characteristics of a stored procedure. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE.

Alter syntaax允许您更改“特征”,但不能更改实际过程本身

以下是创建,修改(注释)然后删除和重新创建的示例：

DROP PROCEDURE myFunc;

DELIMITER //

CREATE PROCEDURE myFunc ()

COMMENT 'test'

BEGIN

SELECT 5;

END //

DELIMITER ;

ALTER PROCEDURE myFunc

COMMENT 'new comment';

CALL myFunc();

DROP PROCEDURE myFunc;

DELIMITER //

CREATE PROCEDURE myFunc ()

COMMENT 'last time'

BEGIN

SELECT 6;

END //

DELIMITER ;

CALL myFunc();

上面的CALL myFunc()语句将返回5然后返回6.

查看存储过程会显示“test”,“new comment”或“last time”的注释,具体取决于您查看过程主体的时间(我不知道如何通过CLI查看注释,但我可以在Navicat中的函数选项卡)