How to make multiple insert into 2 tables at once?

Question

MySQL

Hello!
Given:
There are table1 and table1_meta.
Relationship 1(table1) to many(table1_meta). By column table1_id
Task:
It is necessary to make an insert in table1 and a lot of rows in table1_meta at once.
Questions:
How to make it most competently for insert 1 of the table1 row?
How to do it most competently for insert 10 rows of table1 ?
Thanks everyone for the replies.

Answer 1

At first you do insert 10 rows of table1 and only then set of rows in table1_meta.

Answer 2

You won't be able to insert directly into different tables. Only two requests.

Answer 3

wow-insert-in-one-query is called LOAD DATA INFILE - will insert values ​​from a file. But in 1 table.
so 2 times - it is necessary.

Answer 4

It is possible to try through triggers . But strongly depends on what data goes to the second table.
Perhaps it is possible through transactions.
Give examples of requests.

Answer 5

dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-...
you need a plot:

SET foreign_key_checks=0;
... SQL import statements ...
SET foreign_key_checks=1;

you just need to understand what exactly you are doing, and that the data you insert will not violate the integrity of foreign keys, if everything is ok, then just shove the data into the tables as you like, at least mixed up.