查询工作在MySQL工作台上执行，但在node.js中执行，返回语法有问题

const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

const sql = 'SELECT * FROM your_table WHERE id = ?';
const values = [1];

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

connection.end();

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  charset: 'utf8mb4' // 确保字符编码一致
});

const sql = 'SELECT * FROM your_table WHERE id = ?';
const values = [1];

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

npm install mysql@latest

console.log('Executing SQL:', sql, 'with values:', values);
connection.query(sql, values, (error, results, fields) => {
  if (error) throw error;
  console.log(results);
});

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database',
  charset: 'utf8mb4'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database:', err);
    return;
  }
  console.log('Connected to database');

  const sql = 'SELECT * FROM your_table WHERE id = ?';
  const values = [1];

  connection.query(sql, values, (error, results, fields) => {
    if (error) {
      console.error('Error executing query:', error);
      return;
    }
    console.log('Query results:', results);
  });

  connection.end((err) => {
    if (err) {
      console.error('Error closing connection:', err);
      return;
    }
    console.log('Connection closed');
  });
});