conditional insert operations
Peng Yu <[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CABrM6wmAdadhKdxj7AGPw=0VVag-JaC_BKe01Gcv+UpNqK-EAA@mail.gmail.com> |
Hi, Suppose that I have a table with three columns h1, h2, v. I want to delete all rows with h1=a, and insert rows like the following (data shown in TSV format), only if there is not an entry with h1=a and h2="" (empty), it exists but its v is not equal to a value X. a,A,v1 a,B,v2 ... https://www.sqlite.org/lang_insert.html I am not sure if there is a way to check an entry to know whether new entries can be inserted. Could anybody show me an example if this can be done? -- Regards, Peng _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users