Nodejs获取MySQL数据_nodejs下mysql读取数据库

初次接触nodejs和mysql的使用

写下来记录一下

数据库为test,表为user,结构如下

建立my.js文件

var mysql = require('mysql')

var connection = mysql.createConnection({

host:'localhost',

user:'root',

password:'123',

database:'test'});

connection.connect();

connection.query('select * from user',function(err,results){

if(err) throw err;

console.log('======start=====');

for(i=0;i

{

var id = new String(results[i].uid);

var temp = new String(results[i].name);

var age = new String(results[i].age);

console.log(id.toString()+" "+temp.toString()+" "+age.toString());

}

console.log('======end=======');

});

connection.end();

执行

纯粹记录一下，留着