mysql help:
CREATE TABLE sales1 (
id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
sales_date DATE NOT NULL DEFAULT '0000-00-00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE(id)
(
PARTITION p0 VALUES LESS THAN (5000)
DATA DIRECTORY='d:/s1/data/'
INDEX DIRECTORY = 'd:/s1/idx/',
PARTITION p1 VALUES LESS THAN (10000)
DATA DIRECTORY='e:/s1/data/'
INDEX DIRECTORY = 'e:/s1/idx/',
PARTITION p1 VALUES LESS THAN MAXVALUE
DATA DIRECTORY='f:/s1/data/'
INDEX DIRECTORY = 'f:/s1/idx/'
);