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?