Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    1

    Unanswered: Load Data Infile ... Update

    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?

  2. #2
    Join Date
    Oct 2003
    Posts
    706
    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.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •