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 vote393 views1 answer
Mysql default port
SQL
0 vote359 views1 answer
Raiserror with nowait
SQL
3 votes360 views1 answer
Set default today mysql
SQL
4 votes349 views2 answers
Oracle sql group by date year
SQL
7 votes356 views3 answers
Sql fill table with info from anothe rtable
SQL
1 vote392 views1 answer
Base64 encode sql server
SQL
0 vote366 views2 answers
Call to undefined function mysql_query()
SQL
1 vote391 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote368 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
1 vote358 views1 answer
Window function mysql
SQL