MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Taylor Lewick Date:November 4 2004 9:47pm
Subject:Load data Infile update?
View as plain text  
Can I perform an update on a table using load data infile..?

If I have the following table...

Name   Score  Rank
John   NULL   NULL
Susan  NULL   NULL

And I have a data file that has...

John,95,1
Susan,89,2

Any idea if this can be done?
Thanks,
Thread
Load data Infile update?Taylor Lewick4 Nov
  • Re: Load data Infile update?Gleb Paharenko5 Nov