UPDATE tablename
SET ziduan= ADDTIME(
date(‘2019-07-07’) + INTERVAL 0 HOUR,
time(ziduan)
)
where ID BETWEEN 1 and 100
mysql修改时间字段只修改日期不修改时间内
最新推荐文章于 2024-06-20 10:45:43 发布
UPDATE tablename
SET ziduan= ADDTIME(
date(‘2019-07-07’) + INTERVAL 0 HOUR,
time(ziduan)
)
where ID BETWEEN 1 and 100