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

1 vote132 views1 answer
How to use db.execute
SQL
50 votes222 views6 answers
Sql count duplicate rows
SQL
0 vote122 views1 answer
Why we have to set the password for my sql server
SQL
2 votes148 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote127 views3 answers
How to increase size of column in sql
SQL
0 vote121 views1 answer
Sql compound operators
SQL
0 vote131 views1 answer
How to select a row in sql
SQL
1 vote130 views1 answer
Oracle create as select
SQL
0 vote117 views1 answer
What is logical database schema
SQL
1 vote113 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL