nodejs 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!');

  // 查询语句
  const sql = 'SELECT * FROM your_table';
  connection.query(sql, (err, result) => {
    if (err) throw err;
    console.log(result);

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

const { Sequelize, DataTypes } = require('sequelize');

// 创建 Sequelize 实例
const sequelize = new Sequelize('mysql://your_username:your_password@localhost:3306/your_database');

// 定义模型
const YourModel = sequelize.define('YourModel', {
  // 字段定义
  yourField: {
    type: DataTypes.STRING,
    allowNull: false
  }
}, {
  // 其他配置
});

// 同步模型到数据库
sequelize.sync().then(() => {
  console.log('Database & tables created!');

  // 查询数据
  YourModel.findAll().then(result => {
    console.log(result);
  });
}).catch(err => {
  console.error(err);
});