你的位置:首页 > 软件开发 > 数据库 > MySQL:procedure, function, cursor,handler

MySQL:procedure, function, cursor,handler

发布时间:2016-12-01 22:00:04
Procedure & FunctionProcedure 语法:CREATE [DEFINER = { user | CURRENT_USER }] PROCEDURE sp_name ([proc_parameter[,...]]) [characteristi ...

MySQL:procedure, function, cursor,handler

Procedure & Function

Procedure 语法:

CREATE  [DEFINER = { user | CURRENT_USER }]  PROCEDURE sp_name ([proc_parameter[,...]])  [characteristic ...] routine_bodyproc_parameter:  [ IN | OUT | INOUT ] param_name typetype:  Any valid MySQL data typecharacteristic:  COMMENT 'string' | LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER }begin  Valid SQL routine statementend;

 

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com

原标题:MySQL:procedure, function, cursor,handler

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。