sitelink1 | https://www.w3schools.com/nodejs/nodejs_mysql.asp |
---|---|
sitelink2 | https://blog.naver.com/pass4u/220027954372 |
sitelink3 | |
extra_vars4 | |
extra_vars5 | |
extra_vars6 |
* mysql npm 설치
$ npm install --save mysql
* mysql.js 파일 작성
var mysql = require('mysql');
var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '111111',
database : 'AccountBook'
});
connection.connect(function(err) {
if (err) {
console.error('mysql connection error');
console.error(err);
throw err;
}
});
connection.query('SELECT * FROM expenseList', function (error, results, fields) {
if (error) {
console.log(error.stack);
throw error;
}
console.log(results);
for (var i=0;i<results.length;i++) {
for (var key in results[i]) {
console.log("key : "+key+", value : "+results[i][key]);
}
console.log(results[i].seq+"/"+results[i].roomType+"/"+results[i].food); //column이 seq,roomType,food 인 경우
}
});
connection.end();