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 vote202 views1 answer
Postrgres trunc
SQL
0 vote217 views1 answer
In query in sql
SQL
0 vote208 views1 answer
Postgres list all stored procedures query
SQL
0 vote204 views1 answer
Alter table engine mysql
SQL
5 votes186 views4 answers
Describe table postgres
SQL
0 vote200 views2 answers
How to login to mysql as normal user in ubuntu
SQL
1 vote201 views1 answer
Oracle difference between two dates in years
SQL
0 vote193 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote206 views1 answer
Groupby sort sql hive
SQL
2 votes212 views1 answer
Oracle apex who is connected
SQL