同表查询更新示例

约 153 字小于 1 分钟

MySQLSQL数据库查询优化

次阅读

2023-11-23

这里的内容会被作为摘要

CREATE
TEMPORARY TABLE temp_loan_amount_table AS
SELECT fca.uuid, (fca.amount - fca.interestAmount) AS newLoanAmount
FROM Asset fca
WHERE fca.stateEnum = 'PASS_PAY'
  AND (fca.)
  AND (fca.loanAmount IS NULL OR fca.loanAmount = 0);
UPDATE CoreAsset fca JOIN temp_loan_amount_table tt
ON fca.uuid = tt.uuid
    SET fca.loanAmount = tt.newLoanAmount
WHERE fca.stateEnum = 'PASS_PAY'
  AND (fca.loanAmount is null
   OR fca.loanAmount = 0);

DROP
TEMPORARY TABLE temp_loan_amount_table;

版权所有

版权归属：AkaChou

许可证：署名 4.0 国际 (CC-BY-4.0)