mysql毫秒测试

来源：互联网发布：历史周期律知乎编辑：程序博客网时间：2024/06/04 18:53
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)
阅读全文
0 0