使用mysql/nodejs返回更新的行

const mysql = require('mysql2');

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

// 连接到数据库
connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ', err);
    return;
  }
  console.log('Connected to MySQL database');
});

// 执行更新操作
const updateQuery = 'UPDATE your_table SET column1 = value1, column2 = value2 WHERE condition';
connection.query(updateQuery, (err, result) => {
  if (err) {
    console.error('Error updating rows: ', err);
    return;
  }
  console.log('Updated rows: ', result.affectedRows);
});

// 关闭数据库连接
connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL database connection: ', err);
    return;
  }
  console.log('Closed MySQL database connection');
});