Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?
Seems like the answer is no
Can I you insert data multiple times into the same table with one statement too.
INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');
Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html