Can we insert data into two or more than two tables using one INSERT query ???

Hello DP members,

I am wondering if someone can help me with an example for the question I asking...

Thanks,

Jimmy

 

You cannot insert into multiple tables using one query.

 

You can use a trigger and insert the new data into other tables from a single query.

http://dev.mysql.com/doc/refman/5.0/en/triggers.html

 

It is not possible to insert data into two tables in a single query

 

I never heard about inserting into two different tables using single INSERT statement, may be in future versions.