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 votes226 views1 answer
Docker run postgres locally
SQL
0 vote233 views1 answer
Setval postgres example table id
SQL
0 vote224 views1 answer
Pl/sql loop example
SQL
0 vote261 views1 answer
Trigger vérifier stock
SQL
0 vote238 views1 answer
On sql table data exists
SQL
0 vote239 views1 answer
Char vs varchar2 in sql
SQL
1 vote238 views1 answer
How to change owner in postgres
SQL
0 vote236 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote244 views1 answer
Sql put two columns into one
SQL
1 vote281 views1 answer
Sql select sum group by id laravel
SQL