php - Retrieve id of each INSERT statement in multi query

Question

Is it possible to retrieve id (ua_id is in my case) for each INSERT statement in following SQL request

INSERT INTO users_addresses (ua_user_id, ua_address_id) VALUES (1,1);
INSERT INTO users_addresses (ua_user_id, ua_address_id) VALUES (1,2);
INSERT INTO users_addresses (ua_user_id, ua_address_id) VALUES (1,3);

using mysqli::multi_query() to execute it wheres ua_id is AUTO_INCREMENT primary key?

Answer 1

In MySQL you can use LAST_INSERT_ID() function. You need to use this function each time - after INSERT statement. It gets ID for the last inserted record.

MySQL documentation - LAST_INSERT_ID()