News for hackers. Stuff that matters.

A comment on Mistakes Beginners Make When Working with Databases. Parent comment

Re:Mistakes Beginners Make When Working with Databases by davidw on Wednesday June 08, 2016 @01:06PM (#11863745)
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.

[ Parent | on HN ]
Re:Mistakes Beginners Make When Working with Databases by billmalarky on Wednesday June 08, 2016 @01:20PM (#11863860)
How old was the version of mysql? Even years ago I remember mysql stored the auto increment value separately.
[ Parent | on HN ]