Re: [sqlite] Race condition -- fixed?

> This is true of SQLite because isolation in SQLite > is "SERIALIZABLE". This is the highest level of isolate > provided by SQL. Most client/server database engines > by default implement "READ COMMITTED". The value of > "balance" might change between the SELECT and the > UPDATE in MySQL, for

Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

[Default] On Sat, 27 Oct 2007 16:26:36 +0200, "Michael Ruck" <[EMAIL PROTECTED]> wrote: >Hi, > >I have a table of unique values in the following format: > >CREATE TABLE categories (id INTEGER PRIMARY KEY, category UNIQUE TEXT) > >I want inserts into this table to succeed, even though the

[sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

Hi, I have a table of unique values in the following format: CREATE TABLE categories (id INTEGER PRIMARY KEY, category UNIQUE TEXT) I want inserts into this table to succeed, even though the corresponding entry already exists. So I use inserts in the following format: INSERT OR IGNORE INTO