In an SQL statement that inserts, deletes, or updates many rows, SQLite as well as MySQL InnoDB checks UNIQUE and FOREIGN KEY constraints row-by-row. According to the SQL standard, the default behavior should be deferred checking. http://stackoverflow.com/questions/7703196/sqlite-increment-unique-integer-field _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] Bug: Increment unique integer field John Yani
- Re: [sqlite] Bug: Increment unique integer field Petite Abeille
- Re: [sqlite] Bug: Increment unique integer field Igor Tandetnik
- Re: [sqlite] Bug: Increment unique integer fie... Petite Abeille
- Re: [sqlite] Bug: Increment unique integer... Marc L. Allen
- Re: [sqlite] Bug: Increment unique in... Petite Abeille
- Re: [sqlite] Bug: Increment uniqu... Richard Hipp
- Re: [sqlite] Bug: Increment u... Petite Abeille
- Re: [sqlite] Bug: Increment uniqu... Pavel Ivanov
- Re: [sqlite] Bug: Increment u... Petite Abeille
- Re: [sqlite] Bug: Increment u... Marc L. Allen