NodeJs连接Mysql示例

var mysql = require("mysql");

var connection = mysql.createConnection({
  host: "127.0.0.1",
  user: "root",
  password:"root123456",
  database: "yangtest"
})

connection.connect();

var sql = "SELECT * FROM tusers LIMIT 1 ";
connection.query(sql,[],function(err,result){

  console.log(result);
});
connection.end();