Can an INSERT query return the id of the inserted row?

Question

MySQL

You need to write a query that inserts data and returns the auto-increment id of the newly inserted row. The construction - "INSERT ...... ; SELECT ....." is not suitable.

Answer 1

dev.mysql.com/doc/refman/5.7/en/information-functi...

INSERT INTO sometable VALUES (1, 2);
SELECT * FROM othertable WHERE uid = LAST_INSERT_ID();

Answer 2

procedure?