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 vote276 views1 answer
Recover deleted data from mysql database
SQL
0 vote274 views1 answer
How to connect postgresql database with java
SQL
1 vote267 views1 answer
Psql connect to another database
SQL
0 vote288 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote277 views1 answer
Soql user profile
SQL
11 votes292 views2 answers
Mysql disable safe mode
SQL
9 votes287 views6 answers
Replace sql
SQL
0 vote250 views1 answer
Create dabase postgresql
SQL
0 vote333 views2 answers
Sql query print strings and int
SQL
1 vote268 views1 answer
Mysql connect command
SQL