AnsweredAssumed Answered

Requests:  Are all records unique?

Question asked by Joni Miller Expert on Jun 23, 2016
Latest reply on Jun 23, 2016 by Joni Miller

Chris Ward, can you please help?  I have a mysql db with a table for requests.  I have the requests.id field as primary key.

 

Upon doing LOAD DATA LOCAL INFILE to load each file manually until I get the process figured out, I'm noticing that some of the data files are throwing messages that records were skipped.

 

Is it possible that some of these records have been duplicated in some of the daily data dumps?  Or that the request ID field is re-used?

 

This is the worst one so far.  I've loaded 15 files and so far 3 have had skipped records.

2016-06-23_10-24-56.png

Outcomes