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 vote192 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote163 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote173 views1 answer
Mysql a from on this page has
SQL
0 vote193 views1 answer
.sql File Run in PSQL
SQL
0 vote165 views1 answer
Oracle sql winter time change
SQL
0 vote164 views1 answer
Postgres enumerated type
SQL
0 vote167 views1 answer
Show the colums of table sql
SQL
2 votes160 views1 answer
Sql create database
SQL
1 vote233 views1 answer
Size of all tables in a schema oracle
SQL
5 votes176 views1 answer
Sql use database
SQL