无法在数据库中插入多个复选框数据

// 前端代码
// HTML
<input type="checkbox" name="option" value="option1"> Option 1
<input type="checkbox" name="option" value="option2"> Option 2
<input type="checkbox" name="option" value="option3"> Option 3

// JavaScript
var selectedOptions = [];
var checkboxes = document.getElementsByName("option");
for (var i = 0; i < checkboxes.length; i++) {
  if (checkboxes[i].checked) {
    selectedOptions.push(checkboxes[i].value);
  }
}

// 后端代码（使用Node.js和MySQL作为示例）
// Node.js
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect();

// 插入操作
const options = selectedOptions.join(','); // 将选中的复选框值拼接成字符串
const sql = `INSERT INTO mytable (options) VALUES ('${options}')`;
connection.query(sql, function (error, results, fields) {
  if (error) throw error;
  console.log('Data inserted successfully');
});

// 查询操作
const querySql = 'SELECT * FROM mytable';
connection.query(querySql, function (error, results, fields) {
  if (error) throw error;
  console.log(results);
});

connection.end();