Re: load data local infile

2002-01-04 Thread Douglas Potter
Yes the data is consistent firstname, lastname, address, city... The data is sent to me in eight different files every day. I want to import the data into a mysql database and set a field that is not included in the txt file. The files are sent to me already organized by region and would like to

load data local infile

2002-01-03 Thread Douglas Potter
I want to set a field for all of the records I import while importing using load data local infile. The field is not specified in the file I am importing. Is there a way to do it? Mysql database importing tab delimited file. -