How do I handle transactions in Node.js with MySQL?

How do I handle transactions in Node.js with MySQL?

To handle transactions in Node.js with MySQL, you can use the mysql or mysql2 package. Start by creating a connection and then use the beginTransaction, commit, and rollback methods.

Can you provide a code example?

Sure! Here's a simple example:

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  database: 'test'
});

connection.beginTransaction(err => {
  if (err) throw err;

  connection.query('INSERT INTO users (name) VALUES (?)', ['John'], (error, results) => {
    if (error) {
      return connection.rollback(() => {
        throw error;
      });
    }

    connection.commit(err => {
      if (err) {
        return connection.rollback(() => {
          throw err;
        });
      }
      console.log('Transaction Complete.');
      connection.end();
    });
  });
});

What happens if an error occurs during the transaction?

If an error occurs, you should call the rollback method to revert any changes made during the transaction. This ensures data integrity.