nodejs mysql transactions

Jerome Scott answered on May 1, 2022 Popularity 8/10 Helpfulness 3/10

answer nodejs mysql transactions

nodejs mysql transactions

Comment

connection.beginTransaction(function(err) {
  if (err) { throw err; }
  connection.query('INSERT INTO posts SET title=?', title, function (error, results, fields) {
    if (error) {
      return connection.rollback(function() {
        throw error;
      });
    }
 
    var log = 'Post ' + results.insertId + ' added';
 
    connection.query('INSERT INTO log SET data=?', log, function (error, results, fields) {
      if (error) {
        return connection.rollback(function() {
          throw error;
        });
      }
      connection.commit(function(err) {
        if (err) {
          return connection.rollback(function() {
            throw err;
          });
        }
        console.log('success!');
      });
    });
  });
});

Popularity 8/10 Helpfulness 3/10 Language javascript

Source: www.npmjs.com

Tags: javascript mysql transactions

Link to this answer
Share Copy Link

Contributed on May 01 2022

Jerome Scott

0 Answers Avg Quality 2/10

nodejs mysql transactions

Contents

More Related Answers

nodejs mysql transactions

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.