nodejs mysql的简单使用

npm install mysql

var mysql = require("mysql");
//链接服务器
var db = mysql.createConnection({host:"localhost",user:"root","password":"",database:"20170525"});
db.query("select * from user_table",(err,data)=>{
  if(err){
    console.log("出错了",err);
  }else{
    console.log("成功了",data);
  }
});

执行结果：

image.png