tbl = 'cffeed.list' col = 'url' puts "BEGIN;" for line in ARGF url, rest = line.chomp.split(/\t/) q = url.gsub(/[\\']/) {|c| "\\" + c } puts "INSERT IGNORE INTO #{tbl}(#{col}, upd) VALUES ('#{q}', NOW());" end puts "COMMIT;"