Re: Ruby Mysql inset variable

[Raveendran P]

Hi All,

I got simple solution

require 'mysql'

my_array= ["google.com","yahoo.com"]

db = Mysql::new("localhost", "root", "", "new_development")

my_array.each do |a|
puts a
b = a.collect{|x| x = "'" + x + "'"}
puts b
c = b.join(",")
puts c
sql = "INSERT INTO sites VALUES (3,#{c},0,0);"
db.query(sql)
end

Regards,
P.Raveendran
RF,Chennai,
http://raveendran.wordpress.com