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

2 votes202 views1 answer
Oracle virtual column
SQL
1 vote182 views1 answer
Increase date by one day in sql oracle
SQL
0 vote175 views1 answer
Sql describe
SQL
8 votes197 views1 answer
Ltrim sql
SQL
0 vote196 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote218 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote194 views1 answer
Mysql insert into select transaction c#
SQL
0 vote212 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote192 views1 answer
List all permissions on a table in postgres
SQL
-2 votes186 views1 answer
No module named '_sqlite3
SQL