摘要: 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... 阅读全文
posted @ 2006-04-18 15:35 kylindai 阅读(993) 评论(0) 推荐(0) 编辑
摘要: 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 ... 阅读全文
posted @ 2006-04-18 15:14 kylindai 阅读(581) 评论(0) 推荐(0) 编辑