UPDATE table
SET time = STR_TO_DATE(CONCAT('2023-', DATE_FORMAT(time, '%m-%d')), '%Y-%m-%d')
WHERE YEAR(time) = 2013;
06-01
4079
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-06
305
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-02
611
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
10-29
751
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-02
2235
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
05-12
308
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-15
3500
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
08-03