Forum: Ruby loading data from file with mysql

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
Jon D. (Guest)
on 2006-05-06 13:59
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 topic is locked and can not be replied to.