使用Node.js和MySQL进行连续数据库插入（已将握手入队后无法入队）

我需要将值稳定地插入数据库中。我已经尝试过使用此代码：

var mysql = require("mysql");
const random = require("random");

var con = mysql.createConnection({
  host: "xxx",
  user: "xxx",
  password: "xxx",
  database: "xxx"
});

con.connect(function(err) {
  while (true) {
    if (err) throw err;
    val1_ = random.int((min = 0), (max = 100));
    val2_ = random.int((min = 0), (max = 100));
    val3_ = random.int((min = 0), (max = 100));
    val4_ = random.int((min = 0), (max = 100));
    var sql =
      "INSERT INTO Table (val1, val2, val3, val4)VALUES (" +
      val1_ +
      "," +
      val2_ +
      "," +
      val3_ +
      "," +
      val4_ +
      ")";
    con.query(sql, function(err, result) {
      if (err) throw err;
    });
  }
});

但是我得到了这个[[错误：Cannot enqueue Handshake after already enqueuing a Handshake.] >>我知道这可能不是完成此任务的方法，只是让您了解我想做什么。我该如何解决这个问题？

app.js

使用Node.js和MySQL进行连续数据库插入（已将握手入队后无法入队）

我需要将值稳定地插入数据库中。我已经尝试过使用此代码：

var mysql = require("mysql");
const random = require("random");

var con = mysql.createConnection({
  host: "xxx",
  user: "xxx",
  password: "xxx",
  database: "xxx"
});

con.connect(function(err) {
  while (true) {
    if (err) throw err;
    val1_ = random.int((min = 0), (max = 100));
    val2_ = random.int((min = 0), (max = 100));
    val3_ = random.int((min = 0), (max = 100));
    val4_ = random.int((min = 0), (max = 100));
    var sql =
      "INSERT INTO Table (val1, val2, val3, val4)VALUES (" +
      val1_ +
      "," +
      val2_ +
      "," +
      val3_ +
      "," +
      val4_ +
      ")";
    con.query(sql, function(err, result) {
      if (err) throw err;
    });
  }
});

但是我得到了这个[[错误：Cannot enqueue Handshake after already enqueuing a Handshake.] >>我知道这可能不是完成此任务的方法，只是让您了解我想做什么。我该如何解决这个问题？

app.js