如何将节点express中的多列插入到MySQL数据库中

const express = require('express');
const mysql = require('mysql2');

const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  connectionLimit: 10 // 可选，设置连接池的最大连接数
});

const app = express();

app.post('/insert', (req, res) => {
  const { col1, col2, col3 } = req.body; // 假设客户端通过POST请求发送数据，col1、col2、col3是要插入的多列数据

  const query = `INSERT INTO your_table (col1, col2, col3) VALUES (?, ?, ?)`;
  pool.query(query, [col1, col2, col3], (error, results) => {
    if (error) {
      console.error('Error inserting data:', error);
      res.status(500).json({ error: 'Error inserting data' });
    } else {
      console.log('Data inserted successfully');
      res.status(200).json({ message: 'Data inserted successfully' });
    }
  });
});