为此,请使用INTERVAL 8 MONTH并从当前日期开始获取8个月的记录-select *from yourTableName where yourColumnName>= (CURRENT_DATE() - INTERVAL 8 MONTH);
注意-假设当前日期是:2018-02-06
让我们首先创建一个表-mysql> create table DemoTable (StudentName varchar(100), AdmissionDate date);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values('John','2019-01-21');
mysql> insert into DemoTable values('Chris','2019-10-04');
mysql> insert into DemoTable values('Robert','2018-02-01');
mysql> insert into DemoTable values('David','2019-07-07');
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
这将产生以下输出-+-------------+---------------+
| StudentName | AdmissionDate |
+-------------+---------------+
| John | 2019-01-21 |
| Chris | 2019-10-04 |
| Robert | 2018-02-01 |
| David | 2019-07-07 |
+-------------+---------------+
4 rows in set (0.00 sec)
以下是间隔8个月后获取记录的查询-mysql> select *from DemoTable where AdmissionDate >= (CURRENT_DATE() - INTERVAL 8 MONTH);
这将产生以下输出-+-------------+---------------+
| StudentName | AdmissionDate |
+-------------+---------------+
| John | 2019-01-21 |
| Chris | 2019-10-04 |
| David | 2019-07-07 |
+-------------+---------------+
3 rows in set (0.00 sec)