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

2 votes357 views1 answer
Oracle block
SQL
3 votes336 views2 answers
Enter mysql command line
SQL
5 votes350 views4 answers
Restart the psql server windows
SQL
1 vote335 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote319 views2 answers
Find Overlapping sql
SQL
1 vote324 views1 answer
Mysql best tutorial for beginners
SQL
0 vote336 views1 answer
Oracle sql log to console
SQL
0 vote319 views1 answer
Mysql update privileges
SQL
20 votes337 views5 answers
Sql show tables
SQL
0 vote301 views1 answer
How to check replication lag in mySQL
SQL