在Node.js中将数组作为列插入

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect();

const data = {
  name: 'John',
  age: 25,
  hobbies: ['reading', 'coding', 'gaming']
};

const hobbiesString = JSON.stringify(data.hobbies);

const sql = `INSERT INTO users (name, age, hobbies) VALUES ('${data.name}', ${data.age}, '${hobbiesString}')`;

connection.query(sql, (error, results, fields) => {
  if (error) throw error;
  console.log('Data inserted successfully');
});

connection.end();