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 vote150 views1 answer
Get foreign table names mysql
SQL
0 vote130 views1 answer
Duplicate foreign key constraint name
SQL
0 vote142 views1 answer
Is not null postgresql
SQL
24 votes161 views5 answers
Import dump mysql
SQL
0 vote342 views1 answer
Power bi connect to postgresql
SQL
4 votes138 views1 answer
Postgresql show current database
SQL
0 vote147 views1 answer
Create mysql pool connection python flask
SQL
1 vote305 views3 answers
Sql subquery
SQL
0 vote160 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote141 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL