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
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