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

0 vote140 views1 answer
Postgresql isnull with max
SQL
0 vote207 views1 answer
Do you know sql
SQL
7 votes139 views3 answers
How to check table name in current database sql
SQL
1 vote145 views1 answer
Sql dcl
SQL
1 vote154 views1 answer
Sql current timestamp
SQL
0 vote150 views1 answer
Python mysql show databases
SQL
3 votes143 views1 answer
Sql case update
SQL
0 vote176 views1 answer
SQL Cut part string
SQL
0 vote155 views1 answer
Primary key multiple
SQL
1 vote152 views1 answer
Sql select table header
SQL