title: Updating MySQL table with only unique records?
body: <p>I am googling around and reading posts on this site but not clear what I should I do go with insert unique, records. </p>
  
  <p>I basically have a giant file that that has a single column of data in it that needs to be imported into a db table where several thousand of the records from my text file already exist. </p>
  
  <p>There are no id's in the text file I need to import and what I am reading insert ignore looks to be solving for duplicate ID's. I want new ids created for any of the new records added but obviously I can't have duplicates. </p>
  
  <p>This would ideally be done with load data infile...but really not sure:</p>
  
  <p>Insert IGNORE?
  ON Duplicate Key?</p>