MySQL SELECT查询返回具有特定月份和年份的记录
对于特定月份,请使用MONTH()
,对于年份,请使用YEAR()
方法。让我们首先创建一个表-
mysql> create table DemoTable ( StudentName varchar(40), StudentAdmissionDate date );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable values('Chris','2019-01-21'); mysql> insert into DemoTable values('Robert','2018-09-05'); mysql> insert into DemoTable values('Mike','2019-09-05'); mysql> insert into DemoTable values('David','2019-10-04');
使用select语句显示表中的所有记录-
mysql> select *from DemoTable;
这将产生以下输出-
+-------------+----------------------+ | StudentName | StudentAdmissionDate | +-------------+----------------------+ | Chris | 2019-01-21 | | Robert | 2018-09-05 | | Mike | 2019-09-05 | | David | 2019-10-04 | +-------------+----------------------+ 4 rows in set (0.00 sec)
以下是查询以返回特定月份和年份的记录-
mysql> select *from DemoTable where month(StudentAdmissionDate)=09 and year(StudentAdmissionDate)=2019;
这将产生以下输出-
+-------------+----------------------+ | StudentName | StudentAdmissionDate | +-------------+----------------------+ | Mike | 2019-09-05 | +-------------+----------------------+ 1 row in set (0.00 sec)