Mysql partition error?
- by drake
I have a kinda table like this:
CREATE TABLE test (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
user VARCHAR(30),
time VARCHAR(30),
status VARCHAR(30),
origin VARCHAR(30),
PRIMARY KEY (id)
) ENGINE=MyISAM;
PARTITION BY RANGE(id) (
PARTITION p0 VALUES LESS THAN (500000),
PARTITION p1 VALUES LESS THAN (1000000),
PARTITION p2 VALUES LESS THAN (1500000),
PARTITION p3 VALUES LESS THAN (2000000),
PARTITION p4 VALUES LESS THAN (2500000)
)
I have Three questions:
1) I have here an #1064 error;
2) How can i set split test.user as alphabetic range in partition;
3) How can i check that the partition was successful;