现在我建立了一个触发器对 taba的update,如果old.status<>new.status 则插入到 记录到tabb里面,我只是更新了一条记录,但是发现这个触发器记录在binlog 里面如下面图,图片只是截取部分,下面还有几白条Update_rows,,,,问题是我只是更新了taba里面的一条记录,CREATE
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `tr_ext` AFTER UPDATE ON `taba`
FOR EACH ROW BEGIN
IF OLD.Status <> NEW.Status THEN
INSERT INTO tabb(FID,OldStatus,NewStatus,OperationDate)
VALUES(NEW.FID,OLD.Status,NEW.Status,SYSDATE());
END IF;
END;
$$
DELIMITER ;
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `tr_ext` AFTER UPDATE ON `taba`
FOR EACH ROW BEGIN
IF OLD.Status <> NEW.Status THEN
INSERT INTO tabb(FID,OldStatus,NewStatus,OperationDate)
VALUES(NEW.FID,OLD.Status,NEW.Status,SYSDATE());
END IF;
END;
$$
DELIMITER ;
# at 1630
#131007 20:43:41 server id 1 end_log_pos 1715 Query thread_id=9645921 exec_time=4 error_code=0
SET TIMESTAMP=1381149821/*!*/;
BEGIN
/*!*/;
# at 1715
# at 1807
# at 1886
# at 2886
# at 3862
# at 4838
# at 5814
# at 6790
# at 7766
# at 8742
# at 9718
# at 10694
# at 11670
# at 12646
# at 13622
# at 14598
# at 15574
# at 16550