How do you find out which auto increment was assigned on the last insert ?

SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function.

Note : You don’t have to specify the table name.