[db] Node.js 에서 maria DB 쌓기

1. module install

npm install --save mysql

2. module import

var mysql = require('mysql');

3. db connect

var con = mysql.createConnection({
  host: 'localhost',
  port: 3306,
  user:'root',
  password: 'password',
  database: 'database_name'
});

con.connect();

4. insert db

var sql = 'INSERT INTO table_name(?, ?) VALUES(?, ?)';

con.query(sql, function(err, rows, fields){
  if(err){
    console.log(err);
  }else{
    console.log(rows.name);
  }
});

5. table 초기화

truncate mollu;