メモ：メモ一覧
更新

UPDATE EveryDay5mData A, ( select Z.YMD ,Z.TIME ,COUNT(*) AS CNT FROM EveryDay5mData Z INNER JOIN EveryDay5mData ZZ ON ZZ.BRAND_CODE = Z.BRAND_CODE AND CONCAT(ZZ.YMD,ZZ.TIME) <= CONCAT(Z.YMD,Z.TIME) WHERE Z.BRAND_CODE = 'BIT_ZAIF' GROUP BY Z.YMD ,Z.TIME ) B set A.TIME_NUM = 5000000 - (484 - B.CNT) where A.BRAND_CODE = 'BIT_ZAIF' AND A.YMD = B.YMD AND A.TIME = B.TIME