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

7 votes160 views2 answers
Oracle sql drop index
SQL
2 votes173 views1 answer
Removing view
SQL
0 vote184 views1 answer
Mysql changer nom table
SQL
0 vote174 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote157 views1 answer
Oracle split string
SQL
0 vote162 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote183 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote139 views1 answer
Count the table indatabase
SQL
7 votes179 views3 answers
Convert ansi sql
SQL
1 vote187 views1 answer
Epoch time converter in snowflake
SQL