Question

mysql创建存储过程示例

请问在MySQL中怎么创建一个存储过程，比如简单的。
语法，哪位大侠能提供点学习mysql的网站。

Answer 1

ALTER PROCEDURE proc_name [characteristic ...]

characteristic:

| SQL SECURITY
| COMMENT 'string'

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.
就是说只能改名字和定义不能改里面的内容。要删了重新建。

Answer 2

MySQL教程4 MySQL8运算符、函数、存储过程及新增数据类型 17.之创建带有IN和OUT参数的存储过程 学习猿地