On Sep 24, 2013, at 8:16 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> The first version (INSERT OR FAIL, then UPDATE) won't lead to any SQLite > errors if one of the rows already exists. So you can do a whole lot of both > lines in one transaction and the transaction will still succeed. Is that so? If 'INSERT OR IGNORE' ignores, say, a null constraint, as opposed to, say, a unique one, then you are none the wiser. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users