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 vote292 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote266 views1 answer
Oracle sql date winter time
SQL
0 vote278 views1 answer
Sql server select record with max id
SQL
19 votes238 views1 answer
Sqrt(-1)
SQL
3 votes273 views2 answers
Current year sql
SQL
0 vote274 views1 answer
Mysql query problems and solutions
SQL
-2 votes267 views1 answer
Mysql see users and passwords
SQL
3 votes267 views1 answer
Ms sql skip take
SQL
0 vote281 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
1 vote260 views2 answers
Sql groub by count
SQL