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 vote125 views2 answers
Get date from datetime postgresql
SQL
0 vote181 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote146 views1 answer
Sql runnignsum
SQL
5 votes178 views2 answers
Create table mysql example auto_increment
SQL
3 votes202 views3 answers
Create table in SQL Server
SQL
1 vote169 views1 answer
Pl sql insert into table
SQL
0 vote171 views1 answer
Modificar tipo de dato sql server
SQL
0 vote163 views1 answer
How to find top 3 salary in sql
SQL
0 vote182 views4 answers
Mysql desactivar trigger
SQL
0 vote172 views1 answer
Connect by query in oracle
SQL