在JavaScript函数中从SQL查询中检索变量(重写)

const mysql = require('mysql');

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

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

// 定义要检索的变量
const variableToRetrieve = 'variable_name';

// 创建SQL查询语句
const sqlQuery = `SELECT ${variableToRetrieve} FROM table_name WHERE condition`;

// 执行SQL查询
connection.query(sqlQuery, (error, results) => {
  if (error) throw error;

  // 处理查询结果
  const retrievedVariable = results[0][variableToRetrieve];
  console.log(`Retrieved variable: ${retrievedVariable}`);

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