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 vote272 views1 answer
Mysql random number between 1 and 100
SQL
0 vote250 views3 answers
Mysql delete if not in another table
SQL
1 vote241 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote279 views1 answer
The package java.sql is not accessible
SQL
0 vote250 views1 answer
Luu ckeditor vao mysql
SQL
0 vote285 views1 answer
Sql date with year
SQL
0 vote274 views1 answer
Mysql cli output to a file
SQL
5 votes260 views3 answers
Oracle list columns in schema
SQL
2 votes244 views1 answer
Mysql sysdate
SQL
0 vote244 views1 answer
Systemverilog unique constraint unique values
SQL