CREATE TABLE `pp1` (
`v` varchar(32) NOT NULL,
`k` varchar(128) NOT NULL,
PRIMARY KEY (`k`)
) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
PARTITION BY KEY(k)
PARTITIONS 32;
as easy as you seen
CREATE TABLE `pp1` (
`v` varchar(32) NOT NULL,
`k` varchar(128) NOT NULL,
PRIMARY KEY (`k`)
) ENGINE=InnoDb DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
PARTITION BY KEY(k)
PARTITIONS 32;
as easy as you seen