2021-05-23

node.js连接mysql数据库

个人学习node.js过程记录

var mysql = require('mysql'); 
var connection = mysql.createConnection({
	host: 'localhost',
	user: 'root',
	password: '<密码>',
	port: '3306',
	database: '<数据库名>'
});
connection.connect();
var sql = 'SELECT * FROM <表名>';
//查
var res;
connection.query(sql, function(err, result) {
	if (err) {
		console.log('[SELECT ERROR] - ', err.message);
		return;
	}
	res = result[0];
	console.log('--------------------------SELECT----------------------------');
	console.log(result);
	console.log('------------------------------------------------------------\n\n');
});
connection.end();