使用Node.js进行同步数据库查询

const fs = require('fs');
const data = fs.readFileSync('file.txt', 'utf8');
console.log(data);

const mysql = require('sync-mysql');
const connection = new mysql({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'my_database'
});
const rows = connection.query('SELECT * FROM my_table');
console.log(rows);

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

async function queryDatabase() {
  const rows = await new Promise((resolve, reject) => {
    connection.query('SELECT * FROM my_table', (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
  console.log(rows);
}

queryDatabase();