DROP TABLE IF EXISTS
t_service_statistical
;CREATE TABLE
t_service_statistical
(sysid
bigint(20) NOT NULL,d_type
int(2) NULL DEFAULT NULL COMMENT ‘0:资源保存数据\n1:下载数据\n3:api数据’,d_id
bigint(20) NULL DEFAULT NULL,d_date
varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,d_data
varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,PRIMARY KEY (
sysid
) USING BTREE) ENGINE = oceanbase CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
– Records of t_service_statistical
INSERT INTO t_service_statistical
VALUES (1696920639051102, 1, 1696920638786101, NULL, ‘730’);
INSERT INTO t_service_statistical
VALUES (1696921744942104, 2, 1696920638786101, NULL, ‘730’);