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

3 votes141 views2 answers
Coalesce mysql
SQL
22 votes285 views4 answers
Tsql rename table
SQL
14 votes193 views2 answers
Oracle add attribute to table
SQL
1 vote197 views1 answer
Oracle compile schema
SQL
0 vote165 views1 answer
Postgres add prefix to primary key
SQL
0 vote170 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote176 views1 answer
Sql server change schema of a table
SQL
0 vote197 views1 answer
Mysql sum with group by
SQL
10 votes122 views1 answer
Oracle view dependencies
SQL
3 votes263 views2 answers
Mysql user permission database
SQL