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 vote86 views1 answer
Clear query cache sql server
SQL
4 votes93 views3 answers
Count with where
SQL
0 vote101 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote102 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote99 views1 answer
Android sqlite get rows count
SQL
0 vote161 views1 answer
Postgresql powershell query
SQL
26 votes99 views2 answers
What is the sql statement that finds duplicate usernames
SQL
25 votes129 views1 answer
How to update an attribute in MySQL
SQL
0 vote114 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
13 votes152 views3 answers
Mysqldump structure only
SQL