Running MySQL 4.0. I have a table that needs to be updated on regular basis. For example if there are 2 columns in my table- ID and AMOUNT, I then have a .csv file that I want to use the infile command to update. I want it to verify that the ID fileds match from both the table and the .csv file. If they match I want the AMOUNT field updated with the AMOUNT data from the .csv file. I don't want any new records creted and if there are no matches then no changes should be made. Any ideas?

Load the data from the file into a table, then use separate SQL queries or a short program to update the master from this table.

Each import completely replaces the previous content of the import-table.