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

-1 vote129 views4 answers
Restart mysql server ubuntu
SQL
2 votes106 views1 answer
How to check grants on a package in oracle
SQL
0 vote110 views2 answers
Sql last updated
SQL
0 vote125 views1 answer
Selecting from a view SQL
SQL
0 vote119 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote129 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote122 views1 answer
Generate random data postgresql
SQL
0 vote107 views1 answer
Sql from null to not null
SQL
0 vote127 views2 answers
Replace null with 0 in sql
SQL
2 votes114 views1 answer
Mariadb JSON_EXTRACT
SQL