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'
mysql trigger
Moderator: General Moderators