首页 > 数据库 >MYSQL 数据查询

MYSQL 数据查询

时间:2022-10-11 08:33:09浏览次数:55  
标签:relevant FORMAT 查询 blog 118899906 MYSQL DATE 数据

参考资料:
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');

 

标签:relevant,FORMAT,查询,blog,118899906,MYSQL,DATE,数据
From: https://www.cnblogs.com/y593216/p/16778016.html

相关文章