Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2004
    Location
    Toronto, Canada
    Posts
    1

    Unanswered: PLEASE Help with large UPDATE

    I have a table
    ID, FILENAME, FILEPATH, DATA1, DATA2, DATA3, DATA4

    I already have info in ID, FILENAME, FILEPATH but need to update the DATA fields according to the ID. All the information exists currently in a 15000 row CSV text file where table.DATA1 would actually be CONCAT (DATA_A, DATA_B, DATA_C) from the CSV file and table.DATA 2, 3 and 4 would be straight copies of DATA D, E and F from the CSV file.

    How could I set up the SQL statement to avoid having 15000 seperate "UPDATE DATA1,2,3 WHERE ID=x" statements?

    Any help is most appreciated.
    Last edited by qemart; 04-02-04 at 01:38.

Posting Permissions

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