MySQL查询练习2

mysql> create table article (
    ->     name varchar(30),
    ->     create_date timestamp
    -> );
Query OK, 0 rows affected (0.22 sec)

mysql> insert into article values
    -> ('床前明月光', 20000109202020),
    -> ('疑是地上霜', 20101111121212),
    -> ('举头望明月', 20190606000000),
    -> ('低头思故乡', 20190707070707),
    -> ('今天天气好', 20191212232359),
    -> ('明天天气不好', 20191010101010),
    -> ('拜拜',20191110160259),
    -> ('再见',20191110160200);
Query OK, 8 rows affected (0.12 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> select * from article where create_date between '2019-01-01 10:30:00' and '2019-11-10 16:02:00';
+--------------------+---------------------+
| name               | create_date         |
+--------------------+---------------------+
| 举头望明月         | 2019-06-06 00:00:00 |
| 低头思故乡         | 2019-07-07 07:07:07 |
| 明天天气不好       | 2019-10-10 10:10:10 |
| 再见               | 2019-11-10 16:02:00 |
+--------------------+---------------------+
4 rows in set (0.00 sec)