有主键,感觉是timestamp类型 时区问题,差8小时
testuser112@192.168.133.112:3306 11:47:42 [dbtest13]>select *from t12;
±------±-----±-----±--------------------+
| id | c1 | c2 | ctamp |
±------±-----±-----±--------------------+
| 1 | a | 12 | 2023-03-27 14:33:53 |
| 2 | a | 13 | 2023-03-27 14:34:06 |
| 3 | a | 14 | 2023-03-27 14:34:07 |
| 4 | a | 15 | 2023-03-27 14:34:09 |
| 30001 | NULL | NULL | 2023-03-30 10:26:51 |
±------±-----±-----±--------------------+
5 rows in set (0.00 sec)
testuser112@192.168.133.112:3306 11:47:44 [dbtest13]>show create table t12\G
*************************** 1. row ***************************
Table: t12
Create Table: CREATE TABLE t12
(
id
bigint NOT NULL AUTO_INCREMENT,
c1
varchar(2) COLLATE utf8mb4_bin DEFAULT NULL,
c2
int DEFAULT NULL,
ctamp
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=30002 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
1 row in set (0.00 sec)