node的mysql事务_Node.js mysql事务

一个月前在文档中添加了以下事务示例：

connection.beginTransaction(function(err) {

if (err) { throw err; }

connection.query('INSERT INTO posts SET title=?', title, function(err, result) {

if (err) {

connection.rollback(function() {

throw err;

});

}

var log = 'Post ' + result.insertId + ' added';

connection.query('INSERT INTO log SET data=?', log, function(err, result) {

if (err) {

connection.rollback(function() {

throw err;

});

}

connection.commit(function(err) {

if (err) {

connection.rollback(function() {

throw err;

});

}

console.log('success!');

});

});

});

});