I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an
AUTO-INCREMENT column defined as int unsigned primary key. Records are
regularly added and then later deleted from this table. If the last record
is deleted, the sequence begins at 1 again.
Reading from MySQL (Paul Dubois) pages 94-95, it says that "the values in an
automatically generated series are strictly increasing and not reused", even
if the maximum value is deleted. This applies to 3.23 and up. The sequence
is restarted only if you delete all records from the table using the DELETE
FROM tbl_name syntax.
I am deleting row by row (DELETE FROM tbl_name WHERE...). Shouldn't the
sequence be preserved, i.e. if the last record in the table has value 43 and
I delete it, shouldn't the next record get 44 ?
I am running 3.23.37 on Suse 7.0
Thanks.
Kevin McBrearty
ATG Automation Technologies Group Ltd.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
