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?


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