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 vote99 views1 answer
Woocommerce mysql price table
SQL
0 vote102 views1 answer
Grant privileges of databse to user
SQL
0 vote73 views2 answers
How to combine two sql queries in one result
SQL
0 vote94 views1 answer
Check mysql password with docker container magento 2
SQL
5 votes108 views2 answers
Sql server check port number
SQL
9 votes97 views4 answers
How to remove duplicate in sql
SQL
1 vote117 views1 answer
Oracle drop chain step
SQL
1 vote142 views1 answer
Apex run 404
SQL
0 vote109 views2 answers
MySQL PARTITION BY month automatically
SQL
-1 vote102 views1 answer
Mysql #1064 error
SQL