From: Mike Turco <cit403@...>
Date: 2006-08-25T03:26:39+09:00
Subject: import  txt file to mysql with ruby & load data local ??

I'm trying to run this sql from within a ruby program

LOAD DATA LOCAL INFILE 'C:\\test.txt' INTO TABLE `links` FIELDS 
TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY 
'\r\n'
will this even work with ruby? what should syntax be?


require "rubygems"
require "mysql"

begin

        dbName = "testdb"
        m = Mysql.new("localhost", "root", "")
        m.select_db(dbName)
        result = m.query(???)
        puts "done"
end

??

-- 
Posted via http://www.ruby-forum.com/.