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

8 votes320 views2 answers
Phpmyadmin password
SQL
0 vote381 views1 answer
Oracle list datafiles
SQL
1 vote343 views1 answer
Oracle add proxy
SQL
1 vote341 views1 answer
Mysql batch insert
SQL
9 votes330 views6 answers
Sql insert into
SQL
0 vote338 views1 answer
Postgres declare variable
SQL
0 vote349 views2 answers
Plsql regex match whole word
SQL
0 vote368 views1 answer
Postgresql port 5432 not open
SQL
0 vote358 views1 answer
Asp.net core sql server stored procedure
SQL
6 votes349 views2 answers
Find mysql version linux
SQL