2 ms·
Here's what happens. Perhaps it has been fixed now: * New record is created, with new ID. * Record is deleted. * Database is shut down (cleanly). * Databas
by davidw 10y ago
Here's what happens. Perhaps it has been fixed now:
* New record is created, with new ID.
* Record is deleted.
* Database is shut down (cleanly).
* Database is started again.
* New record is created. It gets the old ID, because it's just looking at the current max(ID) or something like that.
- billmalarky 10y agoHow old was the version of mysql? Even years ago I remember mysql stored the auto increment value separately.