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;