i have a strange problem. I have a massive database with primary key with autoincrement ID plus 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 accordingly?
somehow export the previous values + the id of each row they're ever likely to an excel sheet. tell 'm not to touch the id field in the excel sheet or make it readonly then when you accept it back from them push it through a php script that creates UPDATE instead of INSERT statements..