在尝试将SQL COUNT(*)查询的值用作NodeJS中另一个查询的值时遇到了困难

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'your_database',
});

// 连接数据库
connection.connect();

// 执行COUNT(*)查询
const countQuery = 'SELECT COUNT(*) AS count FROM your_table';
connection.query(countQuery, (error, results) => {
  if (error) throw error;

  const count = results[0].count;

  // 执行另一个查询，使用COUNT(*)查询的结果
  const anotherQuery = `SELECT * FROM another_table WHERE column = ${count}`;
  connection.query(anotherQuery, (error, results) => {
    if (error) throw error;

    // 处理查询结果
    console.log(results);

    // 关闭数据库连接
    connection.end();
  });
});