Hi,
If i want to use "load data infile" into selected column, for example i have
5 column in one table and i only load data into column 1,2,4 and 5 and i use "load
data infile "abc.txt" replace into table test(t1,t2,t4,t5)" but after i load into the
table, the previous data in column 3 become null. How can i load the data from txt
file into selected column and i want to remain the data in column 3 unchanged?
Thank you very much.
regards,
florence
Yahoo! Photos
- A free party for the most "shiok" photo. Join now!