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

4 votes107 views3 answers
Mysql varchar length
SQL
0 vote111 views2 answers
Functions with parameters SQL
SQL
0 vote128 views1 answer
Mssql dockere
SQL
0 vote120 views1 answer
Import sql in postgresql
SQL
1 vote134 views1 answer
Ubuntu access database from terminal
SQL
0 vote124 views1 answer
Sql #region
SQL
0 vote108 views1 answer
Mysql select where text contains
SQL
0 vote137 views2 answers
Suse stop MySQL
SQL
10 votes111 views5 answers
Mysql create user
SQL
1 vote90 views1 answer
Denied
SQL