Re: Getting all changes within a begin; end; transaction
Simon Slavin <[email protected]> Wed, 4 Mar 2020 15:47:52 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 4 Mar 2020, at 3:28pm, Jose Isaias Cabrera <[email protected]> wrote: > The reason why I know is that if I have 238 INSERTS, but I have a constraint , there should be 238 INSERTs the first time I run a set of SQL, but if I run the same SQL again, there should not be any records INSERTED, and thus, the amount should be 0, correct? Can you try the same thing but instead of INSERT use INSERT OR IGNORE ? _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users