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 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored Warning 1618 option ignored INSERT INTO t1 VALUES (NULL, "first", 1); INSERT INTO t1 VALUES (NULL, "second", 2); INSERT INTO t1 VALUES (NULL, "third", 3); ALTER TABLE t1 ADD PARTITION (PARTITION p3 DATA DIRECTORY = 'G:/mysqltest/p3Data' INDEX DIRECTORY = 'H:/mysqltest/p3Index'); Warnings: 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); DROP TABLE t1;