安装:
npm install mysql
示例:
var mysql = require('mysql');
// 1. 创建连接
var connection = mysql.createConnection({
host: 'localhost',
user: 'me',
password: 'secret',
database: 'my_db'
});
// 2. 连接数据库
connection.connect();
// 3. 执行数据操作
connection.query('SELECT * FROM `users`', function(error, results, fields) {
if (error) throw error;
console.log('The solution is: ', results);
});
// 4. 断开连接
connection.end();