MySQL 8.0-13.1.7 ALTER PROCEDURE Statement

最新推荐文章于 2024-08-04 17:35:06 发布

翻译最新推荐文章于 2024-08-04 17:35:06 发布 · 236 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html

文章标签：

#mysql #数据库 #database

Mysql 专栏收录该内容

142 篇文章

订阅专栏

本文介绍如何使用ALTER PROCEDURE语句来修改存储过程的特性，包括注释、语言类型及安全性等，并强调了不能通过此语句修改过程参数或主体的方法。

ALTER PROCEDURE proc_name [characteristic ...]

characteristic: {
    COMMENT 'string'
  | LANGUAGE SQL
  | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
  | SQL SECURITY { DEFINER | INVOKER }
}

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 PROCEDURE语句中可以指定多个更改。但是，不能使用此语句更改存储过程的参数或主体;要进行此类更改，必须使用drop procedure和CREATE procedure删除并重新创建过程

You must have the ALTER ROUTINE privilege for the procedure. By default, that privilege is granted automatically to the procedure creator. This behavior can be changed by disabling the automatic_sp_privileges system variable. See Section 25.2.2, “Stored Routines and MySQL Privileges”.

您必须拥有该过程的ALTER ROUTINE权限。默认情况下，该特权将自动授予过程创建者。可以通过禁用automatic_sp_privileges系统变量来更改此行为。参见25.2.2节，“存储例程和MySQL特权”。