Sqlite insert if not exists

#id column is assumed to be primary key

INSERT INTO destination_table(id,name) 
SELECT id, name
FROM source_table s
WHERE NOT EXISTS (
  SELECT 1
  FROM destination_table d
  WHERE d.id = s.id
);

Similar codes

5 votes286 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote295 views1 answer
Sqlite explain plan
SQL
0 vote289 views1 answer
Select even number id data from table
SQL
11 votes295 views1 answer
Get ddl materialized view oracle
SQL
36 votes353 views6 answers
Change column data type sql
SQL
2 votes290 views1 answer
Oracle kill job by sid
SQL
0 vote300 views1 answer
Rename constraint postgresql
SQL
0 vote305 views1 answer
Ansi sql count duplicate rows
SQL
0 vote237 views1 answer
Oracle sql developer script output limit
SQL
0 vote287 views1 answer
Convert .mdf to .bak
SQL