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 vote336 views1 answer
What is initial catalog in sql connection string
SQL
0 vote317 views4 answers
How to connect form to database
SQL
0 vote330 views1 answer
Sql show table name in result
SQL
2 votes319 views1 answer
How to insert string variable into sqlite database
SQL
1 vote321 views1 answer
Pl sql insert into table
SQL
3 votes339 views1 answer
Postgres select max value
SQL
11 votes349 views2 answers
Having clause in sql
SQL
1 vote277 views2 answers
Delete auto increment mysql
SQL
0 vote295 views1 answer
Procedures and functions in pl/sql
SQL
0 vote299 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL