该查询将为您工作：
SELECt *FROM tableWHERe MonTH(columnName) = MonTH(CURRENT_DATE())AND YEAR(columnName) = YEAR(CURRENT_DATE())
![获取当月的记录[重复]](http://www.mshxw.com/aiimages/31/421340.png "获取当月的记录[重复]")
该查询将为您工作：
SELECt *FROM tableWHERe MonTH(columnName) = MonTH(CURRENT_DATE())AND YEAR(columnName) = YEAR(CURRENT_DATE())
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
