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 vote269 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote245 views1 answer
Oracle sql date summer time
SQL
0 vote252 views1 answer
Mysql trim characters
SQL
0 vote262 views2 answers
How to update date in oracle
SQL
0 vote264 views1 answer
Create relationship with betwen two tables in postgersql
SQL
6 votes269 views1 answer
Wordpress change user password sql
SQL
0 vote262 views1 answer
List all functions and procedures in postgres query
SQL
2 votes247 views2 answers
Function in sql
SQL
0 vote363 views2 answers
Sqlalchemy default value for column
SQL
0 vote269 views1 answer
How to print mysql query of codeigniter query builder
SQL