mysql 存储过程
时间：2021-07-01 10:21:17
帮助过：29人阅读
[DEFINER = { user | CURRENT_USER }]
PROCEDUREsp_name([proc_parameter[,...]])
[characteristic ...] routine_bodyproc_parameter:
[ IN | OUT | INOUT ] param_nametypecharacteristic:
COMMENT‘string‘
| LANGUAGESQL
| [NOT] DETERMINISTIC
| { CONTAINSSQL | NOSQL | READSSQLDATA | MODIFIESSQLDATA }
| SQLSECURITY { DEFINER | INVOKER }
routine_body:
ValidSQLroutinestatement
[begin_label:] BEGIN
[statement_list]
……
END [end_label]mysql 存储过程
标签：存储 roc pre call begin order star sts 数据库
