Keep the existing row when a unique key collides.
Section: Insert, update, delete, and upsert
Ignore duplicates on conflict
sql
sql
INSERT INTO tags (name) VALUES ('sqlite') ON CONFLICT(name) DO NOTHING;Explanation
Useful for de-duplicated lookup tables and seeding scripts.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Insert, update, delete, and upsert