The only guarantees from an auto_increment column (or IDENTITY in MSSQL, and the other names the concept goes by) is that each value will be unique and never smaller than a previous one: so you can rely on the values for ordering but you can not rely on them not to have gaps. Sometimes it is due to transactions that got explicitly rolled back (or implicitly rolled back due to encountering an error). Sometimes it is due to optimisations the query runner makes to reduce contention issues with the counter resource, improving efficiency when there are concurrent updates to the affected table. Sz on ASP.This is not unusual and there are a couple of causes.Alexander Kriegisch on How to clear Google Chrome Redirect Cache for a single URL.Remove non-utf8 characters from string on How to strip invalid characters from an UTF-8 XML file or string in PHP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |