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

11 votes209 views4 answers
Round in sql
SQL
0 vote219 views1 answer
Mysql trigger to delete old data
SQL
1 vote202 views1 answer
Mysql select update same table
SQL
12 votes227 views2 answers
Select into insert sql server
SQL
0 vote217 views2 answers
Identity syntax in sql
SQL
0 vote225 views1 answer
T-sql email validation
SQL
0 vote212 views1 answer
Sql select sum group by id laravel join
SQL
0 vote200 views1 answer
Get week day name sql server
SQL
8 votes210 views1 answer
Unique vs primary key
SQL
2 votes205 views1 answer
Mysql query unique column
SQL