CREATE TABLE `test` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `col1` int(11) NOT NULL DEFAULT '0' , `col2` int(11) NOT NULL DEFAULT '0' , key(id) ) ENGINE=InnoDB /*!50100 PARTITION BY HASH (`col1`) PARTITIONS 16 */; insert into test values(1, 1, 1); commit; select * from test; drop table test;