declare exit handler for sqlexception

BEGIN
 rollback;#或者看自己需求
 GET DIAGNOSTICS CONDITION 1 # dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
        @p2 = MESSAGE_TEXT;
        
    insert into tbl_log_info (SINFO,STYPE,STEMP,srun_info) 
values('proc_','proc_','action',@p2);
  commit;

END;  

/Start transaction/
start transaction;

I finally got it done after spending an afternoon;
I have to say that the process control of mysql is very poor!mysql的流程控制好差劲!
错误发生时经常抓取不到error,code直接赋值null,这样判断事物提交时被坑了一把;
文档里的抓取数据影响行数的功能没测通,输出结果始终是0,可能用法也不对吧,没找到正确姿势.

另外推荐个mysql存储过程调试工具 dbForge Studio for MySQL
使用时记得只在测试库上debugWhen errors occur, I often cannot capture error, code code> directly assigns the value null, so that it is judged that the thing is being tricked when submitting;