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 vote139 views1 answer
View t-sql mail configuration
SQL
0 vote145 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
1 vote142 views1 answer
Oracle lowercase
SQL
0 vote185 views1 answer
Dynamic where clause in sql server stored procedure
SQL
2 votes153 views1 answer
Postgresql create schema in specific database
SQL
3 votes200 views1 answer
How to get yesterday date in sql
SQL
1 vote144 views1 answer
Psql human readable
SQL
0 vote180 views2 answers
Check if sql temp table exists
SQL
11 votes197 views2 answers
You are using safe update mode
SQL
3 votes152 views2 answers
Order by postgresql
SQL