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 vote212 views1 answer
Narural join
SQL
4 votes214 views4 answers
What is primary key
SQL
4 votes218 views1 answer
Force drop all tables postgres
SQL
6 votes203 views1 answer
Rank function in oracle with example
SQL
0 vote222 views1 answer
Postgres set default schema
SQL
2 votes210 views1 answer
Sql server check for value in multiple columns
SQL
3 votes234 views1 answer
Postgres select max value
SQL
1 vote223 views2 answers
Postgresql truncate cascade restart identity
SQL
2 votes225 views2 answers
Install postgresql
SQL
4 votes218 views3 answers
How to describe a table in sqlite3
SQL