Bug #350 | auto_increment field not reset when doing "DELETE FROM table;" | ||
---|---|---|---|
Submitted: | 30 Apr 2003 9:26 | Modified: | 30 Apr 2003 9:41 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S3 (Non-critical) |
Version: | 4.0.12 | OS: | Windows (Windows 2000 Server) |
Assigned to: | CPU Architecture: | Any |
[30 Apr 2003 9:26]
[ name withheld ]
[30 Apr 2003 9:41]
Alexander Keremidarski
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php This is well docummented behaviour. auto_increment values must not be reused as it usualy breaks dependencies in database In old releases before 3.23 auto_increment values were reused after DELETE which was proved to lead to many troubles and in 3.23 this behaviour was changed to current - much more consistant one. If one wants to reuse values it is doable with following syntax: ALTER TABLE SET AUTO_INCERMENT=N;