updating table from file

[amkravets]

Hello,

I have a table and I need to update records in one column. There are 450 records in the table. I know I can insert records to table from file, but is there a way to update records from file? Essentially I just need to change data in column with data in file.

thanks,
Alex

[nemonoman]

essentially you will need to create a program that makes individual update statements based on the contents of the file and update records one by one. There is no other way to do it.

[amkravets]

really?
I would think this is pretty common task and utility such as phpMyAdmin should've had it. Oh, well I guess I'll write one.

thanks,
Alex