node连接mysql

createMySql()



function createMySql() {
    const mysql = require('mysql');
    const connection = mysql.createConnection({
        host: '', //数据库地址
        user: '', //账号
        password: '', //密码
        database: '' //数据库名字
    });

    connection.connect();
    var sql = 'SELECT * FROM USER'; // 查询USER表所有数据
    //查
    connection.query(sql, function (err, result) {
        if (err) {
            console.log('[SELECT ERROR] - ', err.message);
            return;
        }
        console.log(result)
    });
}