text = "1000848-50-9
1000848-52-1
1004775-32-9"

puts "CREATE temporary TABLE `yangdong_tmp_chemical` ("
puts "`cas` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'CAS号'"
puts ");"
puts ""
puts "insert into yangdong_tmp_chemical (cas)"
puts "values"
puts "(\"" + text.split("\n").map{|line| line.strip}.join("\"),(\"") + "\");"