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!