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 vote348 views1 answer
Insert into table with only identity column
SQL
1 vote351 views1 answer
What is in condition in sql
SQL
1 vote309 views1 answer
Import local sql into remote mysql
SQL
0 vote348 views1 answer
Vbscript connect mssql
SQL
1 vote379 views1 answer
How not to sort by average rating
SQL
1 vote339 views1 answer
Oracle truncate partition
SQL
0 vote312 views1 answer
Sql last 7 days
SQL
1 vote355 views1 answer
Sqlalchemy on delete set null
SQL
0 vote327 views2 answers
Update all columns in one update
SQL
5 votes323 views2 answers
Get columns number sql
SQL