CREATE PROCEDURE test() BEGIN /*定义错误,1062是插入重复的订单号的存储过程*/ declare errname condition for 1062; /*exit出现错误后停止执行下一条,CONTINUE 继续执行未完成的存储过程,直至结束*/ declare exit handler for errname begin SELECT -19; end; INSERT INTO sz_log_no(`no`)VALUES('21'); INSERT INTO sz_log_no(`no`)VALUES('21'); END