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

-1 vote197 views1 answer
Mysql #1064 error
SQL
0 vote275 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
34 votes267 views6 answers
Sql change data type
SQL
0 vote199 views1 answer
Mysql two joins
SQL
6 votes215 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote295 views1 answer
Mysql get nested records
SQL
3 votes209 views1 answer
Async await mysql nodejs
SQL
0 vote203 views1 answer
Sql replace id with name from another table
SQL
1 vote213 views1 answer
Increase existing date in sql
SQL
0 vote227 views1 answer
Mysql timediff
SQL