mysql 依赖库

1.基本使用

let mysql = require('mysql');
let Promise = require('bluebird');
let connection = mysql.createConnection({
    connectionLimit:10,
    host:'localhost',
    user:'root',
    password:'2857175230',
    database:'cms',
});
//连接数据库
connection.connect();
let query = Promise.promisify(connection.query).bind(connection);
query('SELECT * FROM account').then((results)=>{
    console.log(results);
});
// connection.query('SELECT * FROM account',function (err, results, fields) {
//     console.log(err);
//     console.log(results);
//     console.log(fields);
// });

2.事务

connection.beginTransaction(function(err){
    if(err) throw err;
    connection.query('update account set balance = balance+10 where id=1',function(err){
        console.log(err,1);
        if(err){
            connection.rollback();
            throw err;
        }else{
            connection.query('update account set balance = balance-10 where id=2',function(err){
                console.log(err,2);
                if(err){
                    connnection.rollback();
                    throw err;
                }else{
                    connection.commit(function(err){
                        console.log(err,3);
                        console.log('提交事务成功了');
                    })
                }
            })
        }
    })
})