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

2 votes127 views1 answer
Sqlplus clear screen
SQL
2 votes188 views3 answers
Xampp mysql database not starting
SQL
8 votes126 views2 answers
Phpmyadmin password
SQL
0 vote128 views1 answer
Remove binlog mysql
SQL
0 vote140 views1 answer
Renombrar tabla mysql
SQL
18 votes136 views2 answers
Sql inner join
SQL
27 votes170 views5 answers
Mysql set password for user
SQL
-1 vote153 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
7 votes144 views2 answers
3rd height salary sql
SQL
-1 vote148 views1 answer
Mysql change database charset and collation
SQL