修改内容为修改yyyy-mm-dd为对应的日期，时间不变
UPDATE `order` set update_time = ADDTIME (date('2021-08-21') + interval 0 hour,time(update_time))若想修改为当前的日期，则为
UPDATE `order` set update_time = ADDTIME (CURDATE() + interval 0 hour,time(update_time))修改内容为修改yyyy-mm-dd为对应的日期，时间不变
UPDATE `order` set update_time = ADDTIME (date('2021-08-21') + interval 0 hour,time(update_time))若想修改为当前的日期，则为
UPDATE `order` set update_time = ADDTIME (CURDATE() + interval 0 hour,time(update_time))
![mysql导入报错 [Err] 1273 – Unknown collation: ‘utf8mb4_0900_ai_ci’](https://oscimg.oschina.net/oscnet/up-43534edd59bd97f0f717a20a6a9d45b790c.png)
评论0