更新多行，使用批量更新是一個好的解決方案還是類似于下面的代碼？. 我想用 id 和文件名更新所有記錄。我確實嘗試在循環內更新，但遷移掛斷并在此塊中花費太長時間。是因為迭代嗎？還是更新語法有問題？謝謝你。＃代碼 for (let i = 0; i < documents.length; i++) {        const prefix = Date.now().toString();        const fileParts = documents[i].filename.split('.');        const finalname = `${fileParts[0]}-${prefix}.${fileParts[1]}`;        // eslint-disable-next-line no-await-in-loop        await queryInterface.sequelize.query(`UPDATE ${EmployeeDocumentsModel.tableName} SET filename='${finalname}' WHERE id=${documents[i].id};`, { transaction });      }＃代碼module.exports = {  up: async (queryInterface) => {    const transaction = await queryInterface.sequelize.transaction();    try       const documents = await sequelizeClient.query(        `SELECT id, filename, COUNT(filename) FROM ${EmployeeDocumentsModel.tableName} GROUP BY filename      HAVING COUNT(filename) > 1;`,        { type: QueryTypes.SELECT },      );      // eslint-disable-next-line no-plusplus      for (let i = 0; i < documents.length; i++) {        const prefix = Date.now().toString();        const fileParts = documents[i].filename.split('.');        const finalname = `${fileParts[0]}-${prefix}.${fileParts[1]}`;        // eslint-disable-next-line no-await-in-loop        await queryInterface.sequelize.query(`UPDATE ${EmployeeDocumentsModel.tableName} SET filename='${finalname}' WHERE id=${documents[i].id};`, { transaction });      }      // eslint-disable-next-line no-unused-vars      // const file = await sequelizeClient.query(      //   `DELETE d1 from ${EmployeeDocumentsModel.tableName} d1 inner join ${EmployeeDocumentsModel.tableName} d2 on d2.id < d1.id and d2.filename = d1.filename and d2.employeeId = d1.employeeId`,      //   { type: QueryTypes.DELETE },      // );