I have one table
another tableentries
Now when I add entry I want to add two records intodetails
tabledetails
ID of
should store intoentries
tables' 2nd column which is fkdetails
Please advice
another tableentries
Now when I add entry I want to add two records intodetails
tabledetails
should store intoentries
tables' 2nd column which is fkdetails
Code: Select all
CREATE TRIGGER add_details AFTER INSERT ON entries
FOR EACH ROW
BEGIN
INSERT INTO details SET entries_id = NEW.id, etc...;
etc...
END;