nodejs实现访问mysql数据库

代码

var mysql=require("mysql")
var connection=mysql.createConnection({
    host:'host',
    port:3306,
    user:'user',
    password:'password',
    database:'home'
})
connection.connect();
connection.query("select * from my_table",function(error,results,fields){
  if(error) throw error;
  console.log(results);  
})
connection.end();

效果