Insert-Ignore

MySQL
Data
Data Quality

Why INSERT IGNORE should not be used

Ronald Bradford
August 16, 2026

Let’s say you’re building a reference table from source data, e.g. a silver medallion table from a primary source. In this example I am using a file of random locations on the globe extracted from OpenStreetMap (OSM) as my primary source.