var mysql = require("mysql");
var TEST_DATABASE = "test";
var TEST_TABLE = "user_data";
var client = mysql.createConnection({user:"root",password:""});
client.connect();
client.query("use test");
client.query("select * from user_data", function (err, rs, fields) {
if(err){
throw err;
}
if(rs){
for(var i = 0; i < rs.length; i++){
console.log("%d\t%s\t%s", rs[i].uid,rs[i].username,rs[i].password);
}
}
})
npm install mysql