执行动态生成的sql脚本时，mysql npm语法错误，但脚本在HeidiSQL中工作正常

let tableName = "users";
let query = "SELECT * FROM " + tableName + " WHERE id = " + userId;

let tableName = "users";
let query = "SELECT * FROM ?? WHERE id = ?";
connection.query(query, [tableName, userId], (error, results) => {
    if (error) throw error;
    console.log(results);
});

let name = "O'Reilly";
let query = "SELECT * FROM users WHERE name = '" + name + "'";

let name = "O'Reilly";
let query = "SELECT * FROM users WHERE name = ?";
connection.query(query, [name], (error, results) => {
    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'
});

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

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