DECLARE CONTINUE HANDLER FOR SQLEXCEPTION

来源:互联网 发布:计算机美工 编辑:程序博客网 时间:2024/06/06 06:33
DECLARE _err INTEGER DEFAULT 0;    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET _err = 1;        DELETE FROM company     WHERE id = i_id;          DELETE FROM operator     WHERE agentid = i_id;        SELECT _err AS `status`;

0 0
原创粉丝点击