Maybe it's just Friday, but I can't figure out what I'm messing up here. Would some kind soul point me to where I'm messing up?
Version 3.25.2 sqlite> create table ids (id int primary key, in_old bool, in_new bool); QUERY PLAN `--SEARCH TABLE sqlite_master USING INTEGER PRIMARY KEY (rowid=?) Run Time: real 0.234 user 0.000000 sys 0.109201 sqlite> insert into ids (id, in_old) select distinct id, 1 from gc_old; QUERY PLAN |--SCAN TABLE gc_old USING COVERING INDEX idx_gc_old_id `--USE TEMP B-TREE FOR DISTINCT Run Time: real 18.050 user 10.530067 sys 1.279208 sqlite> insert into ids (id, in_new) select distinct id, 1 from gc_new on conflict (id) do update set in_new = 1; Run Time: real 0.000 user 0.000000 sys 0.000000 Error: near "do": syntax error _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
