October 8th, 2003, 10:10 PM
Join Date: Oct 2003
Location: Austin, TX
Time spent in forums: 3 m 35 sec
Reputation Power: 0
load data infile
how can i use load data infile to do the following
data file has 5 fields:
table has 4 columns
table colums = (a,b,c,e)
load data infile 'file.txt' into table 'this_table' (a,b,c,,e)
will not work ? is it posable to make it work ?
I want to skip the empty column in the text file.
On a Linux box....
Note: bcp is a microsoft program and will not run on Linux.
Last edited by deterset : November 4th, 2003 at 09:39 AM.