Re: [sqlite] Confusion re UPSERT syntax error

Thanks so much! I figured I was missing something :) Matt Parsons ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Confusion re UPSERT syntax error

On 16 Jan 2019, at 4:59pm, David Raymond wrote: > Also note on quotes, single is for a text literal, double is for identifiers. > So it should be > insert into person ("name") values ('hello')... > or just plain > insert into person (name) values ('hello')... though if you're going to quote your

Re: [sqlite] Confusion re UPSERT syntax error

-Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Matt Sent: Wednesday, January 16, 2019 11:30 AM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Confusion re UPSERT syntax error Hello, I am experimenting with the SQLi

[sqlite] Confusion re UPSERT syntax error

Hello, I am experimenting with the SQLite Upsert syntax: https://www.sqlite.org/lang_UPSERT.html Based on the grammar, I would expect a query like this to work: create table person ( name text primary key count int default 0 ); insert into person ('name') values ('hello') on conflict do upd