创建一个新的tlg表：
创建表主键TableID，自增truncat清空表表分区PartitionOptimize优化表下面代码不完全对，仅复制参考修改
CREATE TABLE os07.tlgxx_tempate (
PRIMARY KEY (TableID, TimeStamp)
) ENGINE = INNODB COLLATE = utf8_general_ci COMMENT = ''
SELECT
TableID,
ValueID,
TimeStamp,
TagValue,
Qaulity,
FROM
os07.tlg13_batchid
WHERE 1 = 0-- Clear Table, Primary Key from 0;
TRUNCATE TABLE tlgxx_tempate;
-- Partition the table
ALTER TABLE tlgxx_tempate
PARTITION BY RANGE(YEAR(TIMESTAMP))
SUBPARTITION BY HASH(TO_DAYS(TIMESTAMP))
SUBPARTITIONS 100
(
PARTITION p0 VALUES LESS THAN (2021),
PARTITION p1 VALUES LESS THAN (2022),
PARTITION p2 VALUES LESS THAN (2023),
PARTITION p3 VALUES LESS THAN (2024),
PARTITION p4 VALUES LESS THAN (2025),
PARTITION p5 VALUES LESS THAN (2026),
PARTITION p6 VALUES LESS THAN (2027),
PARTITION p7 VALUES LESS THAN (2028),
PARTITION p8 VALUES LESS THAN (2029),
PARTITION p9 VALUES LESS THAN (MAXVALUE)
);-- Optimize Partition
ALTER TABLE tlgxx_tempate
OPTIMIZE PARTITION p0,p1,p2,p3,p4,p5,p6,p7,p8,p9
附件：Mysq new tlg table.sql