MySQL Forums
Forum List  »  Partitioning

MyIsam partition by string
Posted by: Chris XX
Date: November 03, 2011 09:32AM

Hello,
Could someone tell me, if it possible in mysql 5.1 to create such table

create table test(
pkname varchar(200) not null,
info varchar(200) not null,
key pknazwa (pkname)
)
PARTITION BY RANGE(pkname)(
PARTITION p0 VALUES IN ('damage'),
PARTITION p1 LESS THAN MAXVALUE
);

I would like to create a table that will store all record with pkname='damage' on partition p0 and when pkname!='damage' will use partition p1.

I my case get I get error:

ERROR 1064 (42000): VALUES value must be of same type as partition function near '),
PARTITION p1 LESS THAN MAXVALUE
)' at line 7

Options: ReplyQuote


Subject
Views
Written By
Posted
MyIsam partition by string
4452
November 03, 2011 09:32AM
1685
November 05, 2011 10:29PM
1672
November 07, 2011 03:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.