update insert or delete

[raouleduke]

I have a database that I want to update on a nightly database, with a CSV file, is there a way to upload the file and have it either insert , delete, or update the records in the database based upon the CSV File.

Thanks in advance.

[Shrike]

Conditional update/insert's on MySQL are quite easy, you can do something like

$result = mysql_query("UPDATE table SET (values) WHERE id = $id");
if(!$result){
  $result = mysql_query("INSERT INTO table VALUES (...)");
}

Deleting is a bit more tricky since theres no frame of reference. I assume that if a record is not in the CSV then it should be deleted?

What are the 'rules' for the process?

[raouleduke]

If the record does not exist in the CSV file then, delete the record, if the record is in the CSV file and the database just update, and if the record is in the CSV file and not in the database insert it into the database.

How is it that I select from the CSV File,

Thanks in advance.