how to update mysql database with new data set?

[olddocks]

i have a strange problem. I have a massive database with primary key being autoincrement ID and other fields. The company i work with often publishes the data in excel sheet and i converted to mysql table.

what if they make new changes to existing data? how do i update my mysql data base accordingly?

[r035198x]

Check the ON DUPLICATE KEY UPDATE clause in the refmanual entry for insert

[olddocks]

thanks

can anything be done with primary key set as auto_increment.

[r035198x]

Do you mean that if they update an existing record, they will use a different key from the one that is in the database?