nodejs 安装mysql

1. npm install mysql --save

2.app.js 

var mysql = require('mysql')
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'toor',
    database: 'bbs'
})

connection.connect()

connection.query('select * from table_name', function(err, res, fields) {
    if(err) throw err
    console.log('res', res)
})

connection.end()