Python-4.37 数据库日期类型

create table student(
	id int,
	name char(6),
	born_year year,
	birth_date date,
	class_time time,
	reg_time datetime
);

insert into student values
(1,'winnie',now(),now(),now(),now());

insert into student values
(2,'allen',"1997","1997-12-12","12:12:12","2017-12-12 12:12:12");

命令行启动数据库，创建表格，创建不同类型的记录

mysql> create table student(id int,name char(6),born_year year,birth_data date,class_time time,reg_time datetime);
Query OK, 0 rows affected (0.25 sec)

mysql> insert into student values(1,'winnie',now(),now(),now(),now());
Query OK, 1 row affected, 1 warning (0.04 sec)

mysql> insert into student values
    -> (2,'allen',"1997","1997-12-12","12:12:12","2017-12-12 12:12:12");
Query OK, 1 row affected (0.03 sec)

mysql> select * from student;
+------+--------+-----------+------------+------------+---------------------+
| id   | name   | born_year | birth_data | class_time | reg_time            |
+------+--------+-----------+------------+------------+---------------------+
|    1 | winnie |      2021 | 2021-03-01 | 14:10:45   | 2021-03-01 14:10:45 |
|    2 | allen   |      1997 | 1997-12-12 | 12:12:12   | 2017-12-12 12:12:12 |
+------+--------+-----------+------------+------------+---------------------+
2 rows in set (0.00 sec)