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

12 votes251 views4 answers
How to check mysql version ubuntu
SQL
0 vote234 views1 answer
Populate db from command line postgres
SQL
0 vote222 views1 answer
Mysql Error Code: 1005
SQL
6 votes226 views2 answers
Mysql get yesterday
SQL
0 vote232 views1 answer
Psql get table data types
SQL
0 vote234 views1 answer
Mysql subdate
SQL
0 vote229 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote211 views1 answer
INSERT INTO table using OpenQuery
SQL
14 votes240 views5 answers
Sql oracle limit
SQL
0 vote241 views1 answer
Mariadb cast null to 0
SQL