Loading data from file with mysql


#1

I’m trying to load a tab delimited .txt file into a mysql table. I set
the OPT_LOCAL_INFILE option but the query only reads the first line of
the .txt file. If I run the same command as a batch file in mysql the
entire file is read. Any thoughts?

jon