DROP TABLE IF EXISTS t1; CREATE TABLE `t1` ( `id` int(11) default NULL ) ENGINE=BLACKHOLE DEFAULT CHARSET=latin1 PARTITION BY HASH (id) ; SELECT * FROM t1; id DROP TABLE t1;