奈寻味导航网 » 文章资讯 » MySQL查询选择两个日期范围之间的所有数据？

MySQL查询选择两个日期范围之间的所有数据？

2024-04-25 06:33:03 352

要选择两个日期范围之间的所有数据，请使用MySQLBETWEEN-

select * from yourTableName where yourColumnName between yourDateValue1 and yourDateValue2;

让我们首先创建一个-

mysql> create table DemoTable1422
   -> (
   -> EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   -> EmployeeName varchar(20),
   -> EmployeeJoiningDate date
   -> );

使用insert在表中插入一些记录-

mysql> insert into DemoTable1422(EmployeeName,EmployeeJoiningDate) values('John','2017-09-28');
mysql> insert into DemoTable1422(EmployeeName,EmployeeJoiningDate) values('Chris','2019-09-29');
mysql> insert into DemoTable1422(EmployeeName,EmployeeJoiningDate) values('Bob','2018-01-31');
mysql> insert into DemoTable1422(EmployeeName,EmployeeJoiningDate) values('Sam','2018-12-21');
mysql> insert into DemoTable1422(EmployeeName,EmployeeJoiningDate) values('Mike','2019-11-10');

使用选择显示表中的所有记录-

mysql> select * from DemoTable1422;

这将产生以下输出-

+------------+--------------+---------------------+
| EmployeeId | EmployeeName | EmployeeJoiningDate |
+------------+--------------+---------------------+
|          1 | John         |       2017-09-28    |
|          2 | Chris        |       2019-09-29    |
|          3 | Bob          |       2018-01-31    |
|          4 | Sam          |       2018-12-21    |
|          5 | Mike         |       2019-11-10    |
+------------+--------------+---------------------+
5 rows in set (0.00 sec)

以下是查询以选择两个日期范围之间的所有数据-

mysql> select * from DemoTable1422 where EmployeeJoiningDate between '2018-09-29' and '2019-09-29';

这将产生以下输出-

+------------+--------------+---------------------+
| EmployeeId | EmployeeName | EmployeeJoiningDate |
+------------+--------------+---------------------+
|          2 | Chris        |      2019-09-29     |
|          4 | Sam          |       2018-12-21    |
+------------+--------------+---------------------+
2 rows in set (0.00 sec)

返回顶部
3162201930
czq8825@qq.com

MySQL查询选择两个日期范围之间的所有数据？

热门推荐

随机推荐