From: Thufir Date: 2008-02-22T18:09:58+09:00 Subject: Re: howto insert data into a database? [fixed] On Fri, 18 Jan 2008 04:12:59 +0900, Phil Pan wrote: > I needed to write: > > system("mysql -u root -pqwerasdf ridespot --execute=\"LOAD DATA LOCAL > INFILE \\\"c:/new.txt\\\" INTO TABLE foo LINES TERMINATED BY '\r\m'\"") Thank you, I'm sure that this will come in handy to insert data into mysql with ruby :) -Thufir