CREATE TABLE `tbl01` (
	`ID` INT(11) NOT NULL,
	`Date` DATETIME(6) NOT NULL,
	`Data` VARBINARY(2000) NOT NULL,
	`a` VARCHAR(100) AS (COLUMN_GET(`Data`,1 AS CHAR(100))) VIRTUAL,
	`b` VARCHAR(100) AS (COLUMN_GET(`Data`,2 AS CHAR(100))) VIRTUAL,
	`c` VARCHAR(100) AS (COLUMN_GET(`Data`,3 AS CHAR(100))) VIRTUAL,
	PRIMARY KEY (`ID`, `Date`)
)
COLLATE='latin1_general_ci'
ROW_FORMAT=COMPRESSED
/*!50100 PARTITION BY RANGE (TO_DAYS(`Date`))
SUBPARTITION BY HASH (`ID`)
SUBPARTITIONS 5
(PARTITION p20181029 VALUES LESS THAN (737361) ENGINE = InnoDB,
 PARTITION p20181030 VALUES LESS THAN (737362) ENGINE = InnoDB,
 PARTITION p20181031 VALUES LESS THAN (737363) ENGINE = InnoDB,
 PARTITION p20181101 VALUES LESS THAN (737364) ENGINE = InnoDB,
 PARTITION p20181102 VALUES LESS THAN (737365) ENGINE = InnoDB,
 PARTITION p20181103 VALUES LESS THAN (737366) ENGINE = InnoDB,
 PARTITION p20181104 VALUES LESS THAN (737367) ENGINE = InnoDB,
 PARTITION p20181105 VALUES LESS THAN (737368) ENGINE = InnoDB,
 PARTITION p20181106 VALUES LESS THAN (737369) ENGINE = InnoDB,
 PARTITION p20181107 VALUES LESS THAN (737370) ENGINE = InnoDB,
 PARTITION p20181108 VALUES LESS THAN (737371) ENGINE = InnoDB,
 PARTITION p20181109 VALUES LESS THAN (737372) ENGINE = InnoDB,
 PARTITION p20181110 VALUES LESS THAN (737373) ENGINE = InnoDB,
 PARTITION p20181111 VALUES LESS THAN (737374) ENGINE = InnoDB,
 PARTITION p20181112 VALUES LESS THAN (737375) ENGINE = InnoDB,
 PARTITION p20181113 VALUES LESS THAN (737376) ENGINE = InnoDB,
 PARTITION p20181114 VALUES LESS THAN (737377) ENGINE = InnoDB,
 PARTITION p20181115 VALUES LESS THAN (737378) ENGINE = InnoDB,
 PARTITION p20181116 VALUES LESS THAN (737379) ENGINE = InnoDB,
 PARTITION p20181117 VALUES LESS THAN (737380) ENGINE = InnoDB,
 PARTITION p20181118 VALUES LESS THAN (737381) ENGINE = InnoDB,
 PARTITION p20181119 VALUES LESS THAN (737382) ENGINE = InnoDB,
 PARTITION p20181120 VALUES LESS THAN (737383) ENGINE = InnoDB,
 PARTITION p20181121 VALUES LESS THAN (737384) ENGINE = InnoDB,
 PARTITION p20181122 VALUES LESS THAN (737385) ENGINE = InnoDB,
 PARTITION p20181123 VALUES LESS THAN (737386) ENGINE = InnoDB,
 PARTITION p20181124 VALUES LESS THAN (737387) ENGINE = InnoDB,
 PARTITION p20181125 VALUES LESS THAN (737388) ENGINE = InnoDB,
 PARTITION p20181126 VALUES LESS THAN (737389) ENGINE = InnoDB,
 PARTITION p20181127 VALUES LESS THAN (737390) ENGINE = InnoDB,
 PARTITION p20181128 VALUES LESS THAN (737391) ENGINE = InnoDB)  */;
 
 
 
 
 
 
INSERT INTO `tbl01` (`ID`, `Date`, `Data`) VALUES (5, '2018-10-29 06:00:00.000000', 0x00030001000402002C03005402039100E102039100E102039100E1);
INSERT INTO `tbl01` (`ID`, `Date`, `Data`) VALUES (5, '2018-10-27 08:00:00.000000', 0x00030001000402002403004C0202911A02049107B7020491101D);
INSERT INTO `tbl01` (`ID`, `Date`, `Data`) VALUES (5, '2018-10-25 10:00:00.000000', 0x00030001000402002C030054020391016D02049109DD02049111DF);

 