使用NodeJS在SQL数据库中查找与ID匹配的编号最高的行？

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database');
});

const query = 'SELECT * FROM mytable WHERE ID = ? ORDER BY Number DESC LIMIT 1';

connection.query(query, [id], (err, result) => {
  if (err) throw err;
  console.log(result);
});

connection.end((err) => {
  if (err) throw err;
  console.log('Disconnected from the database');
});