Page 1 of 1

mysql trigger

Posted: Wed Mar 16, 2011 9:58 am
by gd77
delimiter //
CREATE TRIGGER `tblcon` AFTER INSERT ON `tbl_x`
FOR EACH ROW
BEGIN
INSERT INTO `tbl_y` (`id_title`) VALUES (NEW.id);
INSERT INTO `tbl_z` (`id_title`) VALUES (NEW.id);
END;
delimiter ;


the insert working for the first table 'y' not the second 'z'