摘要:
MySQL 5.0 存储过程 (2)事务的处理: DECLARE c int default 0; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION Set c = 1; SET AUTOCOMMIT = 0; START TRANSACTION; update tp_id set id_value = id_value + st... 阅读全文
摘要:
MySQL 5.0 存储过程 关于NOT FOUND的处理: DECLARE c int default 0; DEClARE v_staff_id int default 0; DECLARE CONTINUE HANDLER FOR NOT FOUND Set c = 1; select staff_id into v_staff_id from tr_staff ... 阅读全文