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 votes370 views3 answers
C# sql select
SQL
10 votes361 views6 answers
Mysql delete duplicates
SQL
0 vote373 views1 answer
Calculate age in sql
SQL
0 vote390 views1 answer
Select all same column value in sql
SQL
1 vote396 views1 answer
Sql order by timestamp
SQL
8 votes402 views2 answers
Mysql grant all privileges to user from any host
SQL
1 vote361 views1 answer
Find difference in dates sql
SQL
0 vote366 views1 answer
Creation d'un trigger sql
SQL
3 votes340 views1 answer
How to check schema privileges in oracle
SQL
7 votes372 views1 answer
Sql limit decimal places
SQL