如何在ruby中向sql查询插入字符串数组

require 'mysql2'

# 创建数据库连接
client = Mysql2::Client.new(
  host: 'localhost',
  username: 'your_username',
  password: 'your_password',
  database: 'your_database'
)

# 假设要插入的字符串数组为 ['value1', 'value2', 'value3']
values = ['value1', 'value2', 'value3']

# 构建SQL查询语句
sql = "INSERT INTO users (column_name) VALUES "

# 为每个值创建占位符
placeholders = values.map { |value| "(?)" }.join(", ")

# 将占位符添加到查询语句中
sql += placeholders

# 执行查询
statement = client.prepare(sql)

# 将值绑定到占位符
values.each_with_index do |value, index|
  statement.bind_param(index + 1, value)
end

# 执行插入操作
statement.execute