I need to check a record for duplicates before inserting. What is the best way to do this for a database having a large number of records without affecting the performance?
INSERT IGNORE INTO table will do the trick.
INSERT IGNORE INTO table
It looks like you're new here. If you want to get involved, click one of these buttons!