MySQL 存储过程模板

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 )
      SELECT
        a.id,
        a.name, 
      FROM tb_example a 
        ;
    
    #恢复隔离级别
    SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;

    #事务提交/回滚模块
    IF sys_ErrCode <> &#