MySQL and insert trigger

Question

MySQL

I interpose in the first table record. It also has an “after insert” trigger that adds an id from the first table to the second. How to implement it?

If I interpose in the trigger request: INSERT INTO table2 VALUES (table2.id = LAST_INSERT_ID()); - "1" is added.
If the query is: INSERT INTO table2 VALUES (table2.id = new.id); - "0".

Answer 1

Ubuntu 10.01 + MySQL 5.1.49, works fine via

INSERT INTO table2 (id) values (NEW.id);