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

5 votes248 views1 answer
How to get all table names in sql query
SQL
0 vote166 views3 answers
Mysql calculate age from date of birth
SQL
0 vote181 views1 answer
Connexion mysql
SQL
11 votes190 views6 answers
Mysql else if
SQL
0 vote187 views1 answer
Sql server change schema of a table
SQL
4 votes215 views3 answers
Sqlite show columns
SQL
0 vote170 views1 answer
Dump only schema
SQL
0 vote181 views1 answer
Sql server list user permissions
SQL
0 vote178 views2 answers
Sql select inside select
SQL
1 vote238 views1 answer
Add time to date sql
SQL