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

0 vote111 views1 answer
Remove mysql from centos 7
SQL
0 vote101 views1 answer
Concat column value of same user in mysql
SQL
5 votes105 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote106 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote102 views1 answer
Sql change primary key to composite key
SQL
2 votes109 views3 answers
Postgres create view
SQL
0 vote113 views1 answer
Sql server select ignore dupplicates
SQL
0 vote104 views1 answer
Database xml sql
SQL
4 votes103 views1 answer
Oracle show error line number
SQL
0 vote104 views1 answer
Sql pivot without aggregate
SQL