参考资料: https://blog.csdn.net/qq_43511677/article/details/118899906?utm_medium=distribute.pc_relevant.none-task-blog-2~default~baidujs_baidulandingword~default-4-118899906-blog-90376824.t0_edu_mix&spm=1001.2101.3001.4242.3&utm_relevant_index=6 查询当月数据: SELECT * FROM data_ts WHERE DATE_FORMAT(created_at,'%Y%m') = DATE_FORMAT(curdate(),'%Y%m');