如何在mysql中使用javascript/nodejs和mysql npm以编程方式关闭自动提交？

const mysql = require('mysql');

// 创建连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 连接到数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database!');

  // 关闭自动提交
  connection.query('SET autocommit = 0', (err, result) => {
    if (err) throw err;
    console.log('Auto commit disabled');

    // 开始事务
    connection.beginTransaction((err) => {
      if (err) throw err;

      // 执行SQL语句
      connection.query('UPDATE accounts SET balance = balance - 100 WHERE id = 1', (err, result) => {
        if (err) {
          return connection.rollback(() => {
            throw err;
          });
        }

        connection.query('UPDATE accounts SET balance = balance + 100 WHERE id = 2', (err, result) => {
          if (err) {
            return connection.rollback(() => {
              throw err;
            });
          }

          // 提交事务
          connection.commit((err) => {
            if (err) {
              return connection.rollback(() => {
                throw err;
              });
            }
            console.log('Transaction committed!');
          });
        });
      });
    });
  });
});