mysql存储过程事务处理、异常处理及日志记录综合实践

创建日志记录表

# 日志记录表
CREATE TABLE `zb_abc`.`zb_log_proc_exec`  (
  `uuid_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行主键',
  `proc_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刷新的存储过程',
  `begin_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `exec_status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行状态',
  `exec_cost_time_s` float NULL DEFAULT NULL COMMENT '执行时间，秒',
  `exec_error` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行异常',
  PRIMARY KEY (`uuid_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '日志记录' ROW_FORMAT = Compact;

创建存储过程

CREATE DEFINER=`zb_abc`@`%` PROCEDURE `zb_bd_store_mer`(
  
)
BEGIN
	#Routine bod