use LOAD DATA INFILE to update

2001-08-23 Thread Osman Omar
Hi, Example, I have data inside my table id model data_in 1 str-de453 20010910 Now I have new update data inside text file eg model date_in str-de453 20010911 How can I use LOAD DATA INFILE REPLACE to update new data into my table ***I read manual but cannot file any

Re: use LOAD DATA INFILE to update

2001-08-23 Thread s. keeling
str-de453 20010911 How can I use LOAD DATA INFILE REPLACE to update new data into my table ***I read manual but cannot file any example*** thanks The definition is (stolen from MySQL by Paul DuBois, pg. 565): load data [low_priority] [local] infile 'file.name' [ignore | replace