MySQL学习代码-3

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
| test_gbk           |
+--------------------+
6 rows in set (0.01 sec)

mysql> USE test;
Database changed
mysql> CREATE TABLE IF NOT EXISTS testtime(
    -> a time
    -> );#TIME类型--dd HH:mm:ss(分隔符不固定：天数 小时，分钟，秒，可负值)
Query OK, 0 rows affected (0.03 sec)

mysql> INSERT testtime VALUES('12:23:45');#HH:mm:ss
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM testtime;
+----------+
| a        |
+----------+
| 12:23:45 |
+----------+
1 row in set (0.00 sec)


mysql> INSERT testtime VALUES('3 10:23:45');#dd HH:ss:mm
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM testtime;
+----------+
| a        |
+----------+
| 12:23:45 |
| 82:23:45 |
+----------+
2 rows in set (0.00 sec)

mysql> INSERT testtime VALUES('3 10-23-45');#;——-
ERROR 1292 (22007): Incorrect time value: '3 10-23-45' for column 'a' at row 1
mysql> INSERT testtime VALUES('10-23-45');
ERROR 1292 (22007): Incorrect time value: '10-23-45' for column 'a' at row 1
mysql> INSERT testtime VALUES('0');
Query OK, 1 row af