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
Subject
Views
Written By
Posted
MyIsam partition by string
4594
November 03, 2011 09:32AM
1774
November 05, 2011 10:29PM
1767
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.