尝试在node-mysql中获取MAX查询的值时出错

const mysql = require('mysql');

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

// 连接到数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database: ' + err.stack);
    return;
  }
  console.log('Connected to database as ID: ' + connection.threadId);
});

// 执行MAX查询
const query = 'SELECT MAX(column_name) AS max_value FROM table_name';
connection.query(query, (error, results, fields) => {
  if (error) {
    console.error('Error executing query: ' + error.stack);
    return;
  }
  
  // 处理查询结果
  const max_value = results[0].max_value;
  console.log('Max value: ' + max_value);
});

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