MySQL Query help

[eluser]@rno[/eluser]
Hi Andriu,

The simple answer is: No.
You cannot insert into two tables at once.
But if you want (as I assume you do) insert all related records in table2 at once than the answer is yes.
You could create a simple sql that says:

Code:

INSERT INTO Table2 (table1_id, description)
SELECT YOUR_NEW_ID_HERE, description FROM Table2 WHERE table1_id = 13

obviously you need to replace the YOUR_NEW_ID_HERE with the newly created ID from table1

Good luck!

Arno