MariaDB [test]> drop table if exists t1; create table t1 (a time); insert into t1 values ('10:20:30'),('10:20:30+'),('2001-01-01 10:20:30'),('2001-01-01 10:20:30+'); show warnings; select * from t1;
|
Query OK, 0 rows affected (0.08 sec)
|
Query OK, 0 rows affected (0.36 sec)
|
Query OK, 4 rows affected, 3 warnings (0.08 sec)
|
Records: 4 Duplicates: 0 Warnings: 3
|
|
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1265 | Data truncated for column 'a' at row 2 |
|
| Note | 1265 | Data truncated for column 'a' at row 3 |
|
| Warning | 1265 | Data truncated for column 'a' at row 4 |
|
+---------+------+----------------------------------------+
|
3 rows in set (0.00 sec)
|
|
+----------+
|
| a |
|
+----------+
|
| 10:20:30 |
|
| 10:20:30 |
|
| 10:20:30 |
|
| 34:20:30 |
|
+----------+
|
4 rows in set (0.00 sec)
|