node使用mysql操作数据库_MySQL

var mysql =require(“mysql”);
console.log(“con….“);

var connection=mysql.createConnection({

"host":"localhost",  "port":3306,  "user":"root",  "password":"wjb1234",  "database":"test"

});

connection.connect();
console.log(“conned…“);

var select =“select * from test “;

connection.query(select,function(err,rows){

if(err) console.log(err.message);     for( var i in rows){          console.log(rows[i]);     }

});

connection.end();