Javascript，关于node.js:如何使代码在数组中存储SQL值

npm install mysql

const mysql = require('mysql');

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

connection.connect();

const sqlValues = [];

// 将SQL值添加到数组中
sqlValues.push('value1');
sqlValues.push('value2');
sqlValues.push('value3');

for (let i = 0; i < sqlValues.length; i++) {
  const sql = 'INSERT INTO 表名 (列名) VALUES (?)';
  const values = [sqlValues[i]];

  connection.query(sql, values, (error, results, fields) => {
    if (error) throw error;
    console.log('插入成功');
  });
}

connection.end();