SQL注入：MySql日期时间类型

时间日期类型

date		日期类型
time		时间类型
datetime	日期时间
timestamp	时间戳
year		年份

创建表

mysql> create table time(
    -> reg1 date,
    -> reg2 time,
    -> reg3 datetime,
    -> reg4 timestamp default current_timestamp on update current_timestamp,
    -> reg5 year);
#create table time(reg1 date,reg2 time,reg3 datetime,reg4 timestamp default current_timestamp on update current_timestamp,reg5 year);

插入数据

mysql> insert into time values(now(),now(),now(),now(),now());

#显示警告
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show warnings;
+-------+------+------------------------------------------------------------------------+
| Level | Code | Message                                                                |
+-------+------+------------------------------------------------------------------------+
| Note  | 1292 | Incorrect date value: '2021-11-06 15:58:46' for column 'reg1' at row 1 |
+-------+------+------------------------------------------------------------------------+
#日期型将时间丢弃时产生报错 ， 但时间型将日期丢弃时未发生报错

显示插入的数据

mysql> select * from time;
+------------+----------+---------------------+---------------------+------+
| reg1       | reg2     | reg3                | reg4                | reg5 |
+------------+----------+---------------------+---------------------+------+
| 2021-11-06 | 15:58:46 | 2021-11-06 15:58:46 | 2021-11-06 15:58:46 | 2021 |
+------------+----------+---------------------+---------------------+------+

插入错误格式数据（显示列名）

mysql> insert into time(reg1,reg2) values('asdas','asdasd');
ERROR 1292 (22007): Incorrect date value: 'asdas' for column 'reg1' at row 1

mysql> show warnings;
+-------+------+-----------------------------------------------------------+
| Level | Code | Message                                                   |
+-------+------+-----------------------------------------------------------+
| Error | 1292 | Incorrect date value: 'asdas' for column 'reg1' at row 1  |
| Error | 1292 | Incorrect time value: 'asdasd' for column 'reg2' at row 1 |
+-------+------+-----------------------------------------------------------+