mysql毫秒测试

mysql> create table t(d1 datetime(2),d2 datetime);
Query OK, 0 rows affected (0.93 sec)

mysql> insert into t values(now(),now());
Query OK, 1 row affected (0.04 sec)

mysql> select * from t;
+------------------------+---------------------+
| d1                     | d2                  |
+------------------------+---------------------+
| 2017-12-14 16:03:09.00 | 2017-12-14 16:03:09 |
+------------------------+---------------------+
1 row in set (0.00 sec)

mysql> insert into t values('2017-12-14 16:03:09.21',now());
Query OK, 1 row affected (0.01 sec)

mysql> select * from t;
+------------------------+---------------------+
| d1                     | d2                  |
+------------------------+---------------------+
| 2017-12-14 16:03:09.00 | 2017-12-14 16:03:09 |
| 2017-12-14 16:03:09.21 | 2017-12-14 16:04:09 |
+------------------------+---------------------+
2 rows in set (0.00 sec)

mysql> drop table t1;
Query OK, 0 rows affected (1.16 sec)

mysql> create table t1(d1 timestamp(2),d2 timestamp);
ERROR 1067 (42000): Invalid default value for 'd2'
mysql> create table t1(d1 timestamp(2));
Query OK, 0 rows affected (0.42 sec)

mysql> insert into t1 values(now());
Query OK, 1 row affected (0.02 sec)

mysql> select * from t1;
+------------------------+
| d1                     |
+------------------------+
| 2017-12-14 16:05:54.00 |
+------------------------+
1 row in set (0.01 sec)

mysql> insert into t values(now(2),now(2));
Query OK, 1 row affected (0.01 sec)

mysql> select * from t;
+------------------------+---------------------+
| d1                     | d2                  |
+------------------------+---------------------+
| 2017-12-14 16:03:09.00 | 2017-12-14 16:03:09 |
| 2017-12-14 16:03:09.21 | 2017-12-14 16:04:09 |
| 2017-12-14 16:06:44.99 | 2017-12-14 16:06:45 |
+------------------------+---------------------+
3 rows in set (0.00 sec)

mysql> delete from t;
Query OK, 3 rows affected (0.05 sec)

mysql> insert into t values(now(2),now(2));
Query OK, 1 row affected (0.01 sec)

mysql> select * from t;
+------------------------+---------------------+
| d1                     | d2                  |
+------------------------+---------------------+
| 2017-12-14 16:07:04.02 | 2017-12-14 16:07:04 |
+------------------------+---------------------+
1 row in set (0.00 sec)