Sqlite insert if not exists

This article is tagged with: Sqlite insert if not exists and mysql

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
);

This article is tagged with: Sqlite insert if not exists and mysql