tencent cloud

	CREATE TABLE `t1` (
	  `id` int DEFAULT NULL,
	  `purchased` varchar(12) DEFAULT NULL,
	  KEY `idx` (`id`,`purchased`) GLOBAL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
	PARTITION BY RANGE (`id`)
	SUBPARTITION BY LIST COLUMNS (`purchased`)
	SUBPARTITION TEMPLATE 
	(SUBPARTITION s0 VALUES IN ('0', '1', '2') ENGINE = InnoDB, 
	 SUBPARTITION s1 VALUES IN ('5', '6', '8') ENGINE = InnoDB) 
	(PARTITION p0 VALUES LESS THAN (1990) , 
	 PARTITION p1 VALUES LESS THAN (1999));

	CREATE TABLE `t2` (
	  `id` int DEFAULT NULL,
	  `purchased` varchar(12) DEFAULT NULL,
	  KEY `idx` (`id`,`purchased`) GLOBAL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
	PARTITION BY RANGE (`id`)
	SUBPARTITION BY LIST COLUMNS (`purchased`, `id`)
	SUBPARTITION TEMPLATE 
	(SUBPARTITION s0 VALUES IN (('0', 1), ('1', 1), ('2', 1995)) ENGINE = InnoDB, 
	 SUBPARTITION s1 VALUES IN (('5' ,5), ('6', 6)) ENGINE = InnoDB) 
	(PARTITION p0 VALUES LESS THAN (1990) , 
	 PARTITION p1 VALUES LESS THAN (1999));

	CREATE TABLE `t3` (
	  `id` int DEFAULT NULL,
	  `purchased` varchar(12) DEFAULT NULL,
	  KEY `idx` (`id`,`purchased`) GLOBAL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
	PARTITION BY RANGE (`id`)
	SUBPARTITION BY RANGE COLUMNS (`purchased`)
	SUBPARTITION TEMPLATE 
	(SUBPARTITION s0 VALUES LESS THAN ('5') ENGINE = InnoDB, 
	 SUBPARTITION s1 VALUES LESS THAN ('8') ENGINE = InnoDB) 
	(PARTITION p0 VALUES LESS THAN (1990) , 
	 PARTITION p1 VALUES LESS THAN (1999));

	CREATE TABLE `t4` (
	  `id` int DEFAULT NULL,
	  `purchased` varchar(12) DEFAULT NULL,
	  KEY `idx` (`id`,`purchased`) GLOBAL
	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
	PARTITION BY RANGE (`id`)
	SUBPARTITION BY RANGE COLUMNS (`purchased`, `id`)
	SUBPARTITION TEMPLATE 
	(SUBPARTITION s0 VALUES LESS THAN ('5', 55) ENGINE = InnoDB, 
	 SUBPARTITION s1 VALUES LESS THAN ('8', 88) ENGINE = InnoDB) 
	(PARTITION p0 VALUES LESS THAN (1990) , 
	 PARTITION p1 VALUES LESS THAN (1999));