mike-h30 wrote on Saturday, January 26, 2008:
I had an earlier post “Error 1062 Duplicate entry ‘0’ for key 1” and I believe it was due to an incorrect mapping on my part of my text file key to table patient_data keys. The primary key in my text file is called “Patient_ID” and begins with value “1000”. Does anyone see any harm in me mapping “Patient_ID” from my text file to the following 4 fields in table patient_data: patient_data.id, patient_data.pid, patient_data.pharmacy_id, and patient_data.fitness?
Regards,
-Mike