用nodejs搭建一个MySQL版的接口

1、先安装mysql

$ npm install mysql

2、直接上代码

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : '123456',
  database : 'dataname'
});
connection.connect();
connection.query('查表的SQL语句', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});