Re: Is this an SQL parsing / ambiguity bug ?

Simon Slavin <[email protected]> Tue, 10 Mar 2020 13:26:38 +0000
Newsgroups gmane.comp.db.sqlite.general
Message-ID <[email protected]>
On 9 Mar 2020, at 8:40pm, Vladimir Vysotsky <[email protected]> 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".

<https://sqlite.org/lang_conflict.html>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users