How to insert into multiple tables in SQL using first insert data?

Question

MySQL

You need to insert a record into the first table, and then add the id of the just inserted table to another. How can I do this without sending the request twice?

Answer 1

INSERT INTO `table1` VALUES(...);
SET @last_id = LAST_INSERT_ID();
INSERT INTO `table2` VALUES (@last_id, ...)