56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.19 |
+-----------+
1 row in set (0.00 sec)
mysql> create table t4(id int,last_update TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Query OK, 0 rows affected (0.03 sec)
mysql> insert into t4(id) values (1);
Query OK, 1 row affected (0.01 sec)
mysql> select * from t4;
+------+---------------------+
| id | last_update |
+------+---------------------+
| 1 | 2020-09-11 09:28:41 |
+------+---------------------+
1 row in set (0.00 sec)
mysql> update t4 set id = 2 where id = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from t4;
+------+---------------------+
| id | last_update |
+------+---------------------+
| 2 | 2020-09-11 09:28:57 |
+------+---------------------+
1 row in set (0.00 sec)