# 安装依赖
cnpm install mysql
1
# 连接 MySQL
var mysql = require('mysql');
var connection = mysql.createConnection({
host: '****************',
user: 'user',
password: 'password',
database: 'blog'
});
connection.connect();
var sql = 'SELECT * FROM cmd';
connection.query(sql, function (error, results, fields) {
if (error) throw error;
console.log('--------------------------results----------------------------');
console.log(results);
console.log('--------------------------fields----------------------------');
console.log(fields);
});
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17