Results 1 to 1 of 1

Thread: MYSQL update from CSV file

  1. 04-15-2004, 01:05 PM #1
    gtomczyk
    gtomczyk is offline Registered User
    Join Date
    Apr 2004
    Posts
    1

    Question 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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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