INSERT into multiple tables

[Anon]

Hi!

I am trying to create one insert statement that will insert data into multiple mysql tables.

I have tried using a query like:

INSERT INTO table1, table2 (table1.column1, table2.column1) VALUES ('data1', 'data2')

but could not get this to work correctly. Please let me know if this is possible.

Thanks!!

[Anon]

You can't do this. Insert is a 1 table operation.