在node中输入npm install mysql
电脑必须安装mysql数据库,创建一个数据库,建立一个表,本教程中用的是nodesmaple,表名是t_user
新建a.js代码:
var mysql = require('mysql');
var conn = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '',
database:'nodesmaple',
port: 3306
});
conn.connect();
conn.query('SELECT 1 + 1 AS solution', function(err, rows, fields) {
if (err) throw err;
console.log('The solution is: ', rows[0].solution);
});
conn.end();
运行a.js
node a.js
完成,ok!