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

0 vote341 views1 answer
Mysql Like(searching in the string)
SQL
11 votes368 views1 answer
Ddl view
SQL
2 votes305 views1 answer
Oracle sql drop column if exists
SQL
1 vote336 views1 answer
Mysql month name extract
SQL
2 votes382 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote349 views1 answer
Copy data from cell to cell mysql
SQL
0 vote285 views1 answer
Mitigation of sql injection
SQL
0 vote345 views1 answer
Mysql enter ubuntu
SQL
0 vote367 views1 answer
Create synonym for dblink in oracle
SQL
4 votes356 views1 answer
Postgresql list sequences
SQL