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 vote201 views1 answer
Ssms connect with connection string
SQL
0 vote191 views1 answer
Subquery aggregation
SQL
1 vote183 views1 answer
Get url of cpanel database hostname
SQL
0 vote205 views1 answer
Sql ignore
SQL
0 vote202 views1 answer
Mysql check if lowercase
SQL
0 vote190 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote216 views1 answer
Get current date in pyspark sql
SQL
0 vote205 views1 answer
Postgresql create table with boolean column
SQL
3 votes255 views1 answer
Mysql group_concat distinct
SQL
0 vote224 views1 answer
Day of the week sqlite
SQL