MySQL查询间隔8个月后获取记录
为此,请使用INTERVAL8MONTH并从当前日期开始获取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)