Node—— 连接MySql，查询数据

一、引入mysql模块
国内淘宝镜像cnpm安装教程

cnpm i -S mysql

二、执行代码

const mysql = require('mysql')

//创建mysql连接
const connect =  mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "123456",
    database: "testMysql",
    multipleStatements: true
})

//sql语句
const sql = `select * from user`;

try {
    //执行sql语句
    connect.query(sql,(err,results)=>{
        if(err){
            console.log('查询失败，原因:' + JSON.stringify(err))
        }else{
            console.log('查询成功', JSON.stringify(results))
        }
    })
} catch (e) {
    console.log(e);
} finally {
    //关闭连接
    connect.end();
}

OK,查询成功