MariaDB [test]> DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a TIME); INSERT INTO t1 VALUES (100000000000000000); SHOW WARNINGS; SELECT * FROM t1;
|
Query OK, 0 rows affected (0.00 sec)
|
|
Query OK, 0 rows affected (0.07 sec)
|
|
Query OK, 1 row affected, 1 warning (0.00 sec)
|
|
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1265 | Data truncated for column 'a' at row 1 |
|
+---------+------+----------------------------------------+
|
1 row in set (0.00 sec)
|
|
+----------+
|
| a |
|
+----------+
|
| 00:00:00 |
|
+----------+
|
1 row in set (0.00 sec)
|