DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( c1 int(10) unsigned NOT NULL AUTO_INCREMENT, c2 varchar(30) NOT NULL, c3 smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (c1) ) ENGINE = MYISAM PARTITION BY HASH(c1)( PARTITION p0 DATA DIRECTORY = 'C:/mysqltest/p0Data' INDEX DIRECTORY = 'D:/mysqltest/p0Index', PARTITION p1, PARTITION p2 DATA DIRECTORY = 'E:/mysqltest/p2Data' INDEX DIRECTORY = 'F:/mysqltest/p2Index' ); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored INSERT INTO t1 VALUES (NULL, "first", 1); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. INSERT INTO t1 VALUES (NULL, "second", 2); INSERT INTO t1 VALUES (NULL, "third", 3); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, `c2` varchar(30) NOT NULL, `c3` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (c1) (PARTITION p0 DATA DIRECTORY = 'C:/mysqltest/p0Data' INDEX DIRECTORY = 'D:/mysqltest/p0Index' ENGINE = MyISAM, PARTITION p1 ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'E:/mysqltest/p2Data' INDEX DIRECTORY = 'F:/mysqltest/p2Index' ENGINE = MyISAM) */ Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. ALTER TABLE t1 ADD PARTITION (PARTITION p3 DATA DIRECTORY = 'G:/mysqltest/p3Data' INDEX DIRECTORY = 'H:/mysqltest/p3Index'); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored INSERT INTO t1 VALUES (NULL, "last", 4); Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, `c2` varchar(30) NOT NULL, `c3` smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 /*!50100 PARTITION BY HASH (c1) (PARTITION p0 DATA DIRECTORY = 'C:/mysqltest/p0Data' INDEX DIRECTORY = 'D:/mysqltest/p0Index' ENGINE = MyISAM, PARTITION p1 ENGINE = MyISAM, PARTITION p2 DATA DIRECTORY = 'E:/mysqltest/p2Data' INDEX DIRECTORY = 'F:/mysqltest/p2Index' ENGINE = MyISAM, PARTITION p3 DATA DIRECTORY = 'G:/mysqltest/p3Data' INDEX DIRECTORY = 'H:/mysqltest/p3Index' ENGINE = MyISAM) */ Warnings: Warning 1287 The partition engine, used by table 'test.t1', is deprecated and will be removed in a future release. Please use native partitioning instead. DROP TABLE t1;