mysql 存储过程
标签：存储 roc pre call begin order star sts 数据库
mysql 存储过程
[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]