从mysql表中获取最后一个插入的ID

Question

How to get the last inserted ID of a table, even if the last x record(s) have been deleted?

x can be 1 and can be like 200

Answer 1

Assuming you're talking about auto incremented IDs:

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'Table'

This will give you the next increment id. To get the last inserted id just minus 1.