nodejs访问mysql

首先安装node-mysql

npm install mysql

接着访问mysql，目前createClient已弃用

The first thing you will run into is that the old Client class is gone and has been replaced with a less ambitious Connection class. So instead of mysql.createClient()

var mysql = require('mysql');

var TEST_DB = "eyuan";

var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'root',
});

connection.connect();

connection.query("USE " + TEST_DB);

connection.query('SELECT * FROM users',
  function selectCb(err, results, fields) {
    if (err) {
      throw err;
    }

    console.log(results);
    //console.log(fields);
  }
);

connection.end();

由于node-mysql处于不断更新中，最新的使用方法还是去找官方的，(https://github.com/felixge/node-mysql)

最新版本已加入连接池pool。