Node.js——mysql

准备工作：需要nodejs安装mysql模块

cnpm install mysql


查询数据

var mysql = require("mysql");
var connection = mysql.createConnection({host:'localhost',user:'root',password:'admin',database:'studb'
});
var connect =connection.connect();
console.log(connect);var sql = 'SELECT * FROM stu';
//查
connection.query(sql,function (err, result) {if(err){console.log('[SELECT ERROR] - ',err.message);return;}console.log('--------------------------SELECT----------------------------');console.log(result);console.log('------------------------------------------------------------\n\n');
});connection.end();


其他相关操作：
https://www.runoob.com/nodejs/nodejs-mysql.html