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 vote143 views1 answer
PGSQL dynamic table name
SQL
1 vote155 views1 answer
Mysql select all and rename one
SQL
1 vote121 views1 answer
Oracle rolling back
SQL
2 votes91 views1 answer
Sql float to int
SQL
1 vote129 views2 answers
Mysql spring boot application.properties
SQL
7 votes137 views1 answer
Oracle pagination query offset
SQL
0 vote154 views1 answer
Sql select first and last record of each group
SQL
-1 vote212 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote134 views1 answer
Normalization in database 2nd normal form
SQL
1 vote131 views1 answer
Sql first
SQL