Re: transaction not work for trigger table

[William Chiquito]

Hi kilin,

Try:

CREATE TABLE `t1` (
  `id` int(11) default NULL,
  `fecha` datetime default NULL
) ENGINE=InnoDB;

CREATE TABLE `t2` (
  `id` int(11) default NULL,
  `fecha` datetime default NULL
) ENGINE=InnoDB;

DELIMITER $$

CREATE TRIGGER `trgaitestt1` AFTER INSERT ON `t1`
FOR EACH ROW
BEGIN
	INSERT INTO t2 VALUES (NEW.id, NEW.fecha);
END$$

DELIMITER ;

START TRANSACTION;
INSERT INTO t1 VALUES (1, NOW()), (2, NOW()), (3, NOW()), (4, NOW());
ROLLBACK;

SELECT * FROM t1;