[Node.js] mySQL 연동

.Install mySQL module from npm

- mySQL module 설치   npm i mysql 

.mySQL 연동

var mysql      = require('mysql');
 
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : '',
  password : '',
  database : 'fintech'
});
 
connection.connect();
 
var query = 'select * from fintech.user'
connection.query(query, function (error, results, fields) {
  if (error) throw error;
  console.log('All user information: ', results);
});
 
connection.end();

line 1) mysql 모듈 불러오기

line 3) mysql Connection 생성

line 5, 6) userID, userPassword 입력

line 7) database 이름 입력

line 12) query문 작성

--