1.新建普通表 CREATE TABLE data(id int(30) ,time int(12), sarlay decimal(12,2)); 2.插入数据 INSERT INTO data VALUES (1,201911,10000), (2,201912, 12000), (3,201910, 11000), (4,202001,13000), (5,202001,15000), (6,202004,16000), (7,202004, 17000), (8,202004, 180000); 3.建立LIST分区表 CREATE TABLE data_list(id int(30)