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

1 vote132 views2 answers
Mysql current user
SQL
0 vote146 views1 answer
Select row with latest date mysql
SQL
1 vote146 views1 answer
Sql select table header
SQL
0 vote149 views1 answer
Laravel migration sql dump
SQL
6 votes145 views1 answer
Oracle trigger after logon on schema
SQL
15 votes147 views2 answers
How to know the username of postgresql
SQL
0 vote137 views1 answer
Apt install sql server
SQL
0 vote144 views1 answer
H2 auto increment and unique
SQL
0 vote134 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote138 views1 answer
List column names of multiple tables psql
SQL