On 3/10/20, Simon Slavin <slav...@bigfraud.org> wrote: > On 9 Mar 2020, at 8:40pm, Vladimir Vysotsky <tri...@gmail.com> wrote: > >> sqlite> insert into dst(id) select id from src on conflict do nothing; >> Error: near "do": syntax error > > SQLite does not understand "DO NOTHING". You probably want "ON CONFLICT > IGNORE".
I think Vlad is trying to do an upsert, which does have a DO NOTHING syntax that I copied from postgres. The parsing ambiguity that Vlad is complaining about (if I understand him correctly) is documented at the bottom of the upsert page: https://www.sqlite.org/lang_UPSERT.html#parseambig -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
