更新时间:2022-06-22 10:21:55
UPDATE t_transaction tu JOIN ( SELECT code, MAX(flag) AS flag FROM t_transaction GROUP BY code ) t ON tu.code = t.code SET tu.flag = t.flag
MySQL-更新所有记录以匹配组中的最大值