牛逼的数据类型：date和time之最佳实践-亲试ok
mysql> create table test1(n1 date,n2 time);
Query OK, 0 rows affected (0.15 sec)
mysql> insert into test1(n1,n2) values(now(),now());
Query OK, 1 row affected, 1 warning (0.19 sec)
mysql> select * from test1;
+------------+----------+
| n1 | n2 |
+------------+----------+
| 2020-06-15 | 03:53:03 |
+------------+----------+
1 row in set (0.00 sec)
mysql> insert into test1(n1,n2) values(now()+1,now()+1);
Query OK, 1 row affected, 2 warnings (0.08 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from test1;
+------------+----------+
| n1 | n2 |
+------------+----------+
| 2020-06-15 | 03:53:03 |
| 2020-06-15 | 03:54:12 |
+------------+----------+
2 rows in set (0.00 sec)
创建时间：2021-12-22 10:19
넶浏览量：0
