Database mysql basic (mysql 설치, 접속, 조회)

$ npm install --save mysql

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();