-
MYSQL update from CSV file
Hello,
I currently have MYSQL and PHP installed on a LInux box. I have created some large tables and populated them with data.
I want to modify/update some of the values of a couple of fields in about 100-200 records in one of my tables. I create a query which has about 5 fields. BAsically id, fname, lname, and the 2 fields I wish to update and export that data to csv file. From there I load the file into excel, modify the 2 fields for each record and then save as CSV file.
My question, Is there a way to perform an SQL update on a table from this CSV file; where I need to update only the to columns/fields, but only those records.. not the entire table..
My apologies if I did not make too much sense.
thanks
Greg
Last edited by gtomczyk; 04-15-2004 at 01:22 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|