js数据库操作 mysql

npm install mysql

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 MySQL database!');
});

connection.query('SELECT * FROM your_table', (err, results) => {
  if (err) throw err;
  console.log(results);
});

const mysql = require('mysql2/promise');

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

  try {
    const [results] = await connection.execute('SELECT * FROM your_table');
    console.log(results);
  } catch (err) {
    throw err;
  } finally {
    await connection.end();
  }
}

queryDatabase();