UPDATE lqcv_behavior_stat_inday a1
INNER JOIN (
SELECT
substring( stat_day, 1, 4 ) AS YEAR,
substring( stat_day, 5, 2 ) AS MONTH,
substring( stat_day, 7, 2 ) AS DAY,
stat_day,
id
FROM
lqcv_behavior_stat_inday
) a2 ON a1.id = a2.id
SET a1.YEAR = a2.YEAR,
a1.MONTH = a2.MONTH,
a1.DAY = a2.DAY
mysql update 根据一个字段更新另一个字段
最新推荐文章于 2024-04-21 22:11:55 发布