mysql 存储过程模板:
CREATE PROCEDURE example.proc_Example()
SQL SECURITY INVOKER
BEGIN
#Author: zyz
#Create: 2018-09-11
#存储过程示例
#日志记录定义模块
DECLARE sys_StartTime datetime;
DECLARE sys_ErrCode varchar(5) DEFAULT '00000';
DECLARE sys_ErrMessage varchar(200);
DECLARE IsSuc tinyint(1);
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
GET DIAGNOSTICS CONDITION 1
sys_ErrCode = RETURNED_SQLSTATE, sys_ErrMessage = MESSAGE_TEXT;
END;
SET sys_StartTime = NOW();
#创建临时表
CREATE TEMPORARY TABLE tm_example(
ID int,
name varchar(50)
);
#开启事务
START TRANSACTION;
#修改隔离级别,防止对业务表过长的共享锁占用
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
#处理数据
INSERT INTO tm_example(id, name )