LAST_INSERT_ID will return the last value assigned by Auto_increment and it is not required to specify the table name. Post navigation What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table? How can you see all indexes defined for a table?