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
转载于:https://www.cnblogs.com/sunvince/archive/2010/11/17/2037665.html