mysql> DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DATE, b DATETIME, c TIMESTAMP); SET SQL_MODE='no_zero_date'; INSERT INTO t1 VALUES (0,0,0); SHOW WARNINGS;
|
Query OK, 0 rows affected (0.05 sec)
|
|
Query OK, 0 rows affected (0.21 sec)
|
|
Query OK, 0 rows affected (0.00 sec)
|
|
Query OK, 1 row affected, 3 warnings (0.00 sec)
|
|
+---------+------+--------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------+
|
| Warning | 1264 | Out of range value for column 'a' at row 1 |
|
| Warning | 1264 | Out of range value for column 'b' at row 1 |
|
| Warning | 1265 | Data truncated for column 'c' at row 1 |
|
+---------+------+--------------------------------------------+
|
3 rows in set (0.00 sec)
|