Node.js学习-Node.js入门-09MySql

使用包

• mysql

安装

npm init -y
npm install mysql

var mysql = require('mysql');
//创建连接
var connection = mysql.createConnection({
	host:'localhost',
	user:'xx',
	password:'xx',
	database:'xxx'
});
//连接数据库
connection.connect();
//执行操作
connection.query('select * from xxx',function(err,result,fields){
	if(err) throw err;
	console.log('xxx');
});