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 vote270 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote190 views1 answer
Multiple tricky query in sql server
SQL
2 votes144 views2 answers
Mysql get last character of string
SQL
0 vote210 views1 answer
Sql_inner_join
SQL
0 vote280 views1 answer
Python mysql check if database exists
SQL
0 vote215 views1 answer
Mysql join only one column
SQL
2 votes192 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote197 views1 answer
Sql search all columns of database oracle sql
SQL
20 votes184 views2 answers
Counting in sql
SQL
0 vote209 views1 answer
Query archive mode
SQL