On 7 Jul 2018, at 3:07pm, Paul van Helden <p...@planetgis.co.za> wrote:
> INSERT INTO T1 (A) SELECT A FROM T2 ON CONFLICT(A) DO NOTHING;
It's possible that many people miss this construction because SQLite has
INSERT OR IGNORE INTO T1 (A) SELECT A FROM T2;
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
