DROP TABLE IF EXISTS `dbname`.`tabname`; CREATE TABLE `dbname`.`tabname` ( `id` int NOT NULL AUTO_INCREMENT, `pwhash` varchar(768) NOT NULL, `count` varchar(2) NOT NULL, PRIMARY KEY (`id`), KEY `pwhash_INDEX` (`pwhash`) ) ENGINE=InnoDB /*!50100 PARTITION BY HASH (`id`) PARTITIONS 128 */ ; SHOW CREATE TABLE `dbname`.`tabname`;