9 lines
374 B
Plaintext
9 lines
374 B
Plaintext
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(a INT,b INT,KEY (a)) PARTITION BY HASH (a) PARTITIONS 3;
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t1
|
|
ALTER TABLE t1 ADD PARTITION(PARTITION p3 DATA DIRECTORY='G:/mysqltest/p3Data' INDEX DIRECTORY='H:/mysqltest/p3Index');
|
|
ERROR HY000: Got error 209 'Specifying DATA DIRECTORY for an individual table is not supported.' from XENGINE
|
|
DROP TABLE t1;
|