Loading data from file with mysql

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs