我检查了文档,但找不到任何可以解释这一点的东西。
mysql> SELECT * FROM information_schema.`TABLES` WHERE table_schema='myschema' AND TABLE_NAME ='mytable' \G;
*************************** 1. row ***************************
TABLE_CATALOG: def
TABLE_SCHEMA: myschema
TABLE_NAME: mytable
TABLE_TYPE: BASE TABLE
ENGINE: InnoDB
VERSION: 10
ROW_FORMAT: Dynamic
TABLE_ROWS: 262354
AVG_ROW_LENGTH: 114
DATA_LENGTH: 30015488
MAX_DATA_LENGTH: 0
INDEX_LENGTH: 0
DATA_FREE: 4194304
AUTO_INCREMENT: NULL
CREATE_TIME: 2022-05-17 12:00:32
UPDATE_TIME: 2022-05-17 06:00:37
CHECK_TIME: NULL
TABLE_COLLATION: utf8mb4_general_ci
CHECKSUM: NULL
CREATE_OPTIONS:
TABLE_COMMENT:
1 row in set (0,04 sec)
如您所见,看起来该表是在更新后创建的。知道什么会导致这种情况吗?
编辑:这是架构:
show create table myschema.mytable \G;
| mytable | CREATE TABLE `mytable` (
`app_id` char(27) NOT NULL,
`ref_id` int unsigned NOT NULL,
`value` decimal(10,5) unsigned NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`app_id`,`ref_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci |