如何使用node js在mysql不同列中插入json数组对象

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',     // MySQL数据库主机地址
  user: 'your_username', // MySQL数据库用户名
  password: 'your_password', // MySQL数据库密码
  database: 'your_database'  // MySQL数据库名称
});

// 建立连接
connection.connect();

const data = [
  {
    name: 'John',
    age: 25,
    city: 'New York'
  },
  {
    name: 'Jane',
    age: 30,
    city: 'Los Angeles'
  }
];

const jsonData = JSON.stringify(data);

const sql = `INSERT INTO your_table (column1, column2, column3) VALUES ?`;

// 执行SQL语句
connection.query(sql, [[jsonData]], (error, results) => {
  if (error) throw error;
  console.log('Inserted successfully!');
});