Hi.
If your table has a unique index on field 'name', then use load data infile 'file' replace into table 'table'; "Lewick, Taylor" <[EMAIL PROTECTED]> wrote: > 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, > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
