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 vote280 views2 answers
Find Overlapping sql
SQL
4 votes306 views2 answers
Sql offset
SQL
2 votes304 views1 answer
Sql server case sensitive search
SQL
0 vote322 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote309 views1 answer
Sql convert unix time to date
SQL
2 votes308 views1 answer
Flask sqlalchemy boolean field
SQL
14 votes309 views5 answers
Sql oracle limit
SQL
1 vote298 views1 answer
Psql autocomplete for mac brew install
SQL
-1 vote316 views1 answer
Pl sql drop trigger
SQL
4 votes321 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL