Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Clarification the UPSERT documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | branch-3.31 |
Files: | files | file ages | folders |
SHA3-256: |
271f68663676c6cc3f1ace9cd19800ed |
User & Date: | drh 2020-02-06 23:40:47.796 |
Context
2020-02-21
| ||
15:57 | Fix typos in the testing.html document. (check-in: d4e9b24066 user: drh tags: branch-3.31) | |
2020-02-06
| ||
23:40 | Clarification the UPSERT documentation. (check-in: 271f686636 user: drh tags: branch-3.31) | |
2020-01-31
| ||
20:15 | Attempt to clarify the CREATE TABLE documentation. In the generated column documentation, make it clear that SQLite deliberately ignores the collating sequence of the AS expression when determining the collating sequence of the generated column. (check-in: 91fa93da86 user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
3711 3712 3713 3714 3715 3716 3717 | INSERT INTO vocabulary(word) VALUES('jovial') ON CONFLICT(word) DO UPDATE SET count=count+1; </pre></blockquote> <p>The upsert above inserts the new vocabulary word "jovial" if that word is not already in the dictionary, or if it is already in the dictionary, it increments the counter. The "count+1" expression | | | 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 | INSERT INTO vocabulary(word) VALUES('jovial') ON CONFLICT(word) DO UPDATE SET count=count+1; </pre></blockquote> <p>The upsert above inserts the new vocabulary word "jovial" if that word is not already in the dictionary, or if it is already in the dictionary, it increments the counter. The "count+1" expression could also be written as "vocabulary.count+1". PostgreSQL requires the second form, but SQLite accepts either. <blockquote><pre> CREATE TABLE phonebook(name TEXT PRIMARY KEY, phonenumber TEXT); INSERT INTO phonebook(name,phonenumber) VALUES('Alice','704-555-1212') ON CONFLICT(name) DO UPDATE SET phonenumber=excluded.phonenumber; </pre></blockquote> |
︙ | ︙ |