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 vote175 views1 answer
Stored procedure function relation
SQL
42 votes273 views6 answers
Rename table sql server
SQL
1 vote171 views1 answer
Declare table variable
SQL
0 vote211 views1 answer
Postgres list users and roles
SQL
0 vote211 views1 answer
Finding leap year in sql
SQL
2 votes236 views1 answer
Mariadb json select
SQL
49 votes257 views6 answers
Alter table add column
SQL
12 votes169 views4 answers
Mysql get date difference in hours
SQL
1 vote223 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote198 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL