Lo si fa attraverso una variabile.
INSERT INTO table1 (id,value) VALUES(1,'test'); SET @last_id := (SELECT LAST_INSERT_ID()); INSERT INTO table2 (id,colName) VALUES(@last_id,"newVal_1");