Detailed steps to modify MySQL stored procedures

Preface

In actual development, business requirements are often modified, so it is inevitable to modify the characteristics of the stored procedure.

In MySQL, use the ALTER statement to modify the characteristics of a stored procedure

Syntax

ALTER {PROCEDURE | FUNCTION} sp_name [characteristic……]

Parameter Description

• Sp_name, which indicates the name of the stored procedure or function
• Characteristic, which part of the stored procedure is to be modified
• The values ​​of Characteristic are as follows
• CONTAINS SQL means that the subroutine contains SQL statements, but does not contain statements that read or write data.
• NO SQL, indicating that the subroutine does not contain SQL statements
• READS SQL DATA, indicating that the subroutine contains statements that read data
• MODIFIES DATA, indicating that the subroutine contains statements for writing data
• SQL SECURITY {DEFINER | INVOKER}, specifies who has permission to execute
• DEFINER, which means that only the definer can execute it.
• INVOKER, indicating that the caller can execute
• COMMENT'string', indicating comment information

Modify the definition of the stored procedure CountProc1

Change the read and write permissions to MODIFIES SQL DATA and specify that the caller can execute

View modified information

Currently, MySQL does not provide code modification for existing stored procedures.

If you must modify the diam of a stored procedure, you must first delete the stored procedure and then rewrite the code or create a new stored procedure.

This is the end of this article about modifying MySQL stored procedures. For more relevant content about modifying MySQL stored procedures, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!