MySQL Forums
Forum List  »  Partitioning

Re: PARTITION BY RANGE (CHARACTER BASIS) ?
Posted by: sonam agarwal
Date: April 13, 2010 07:53PM

thanks for your response,
but mysql 5.5 have this feature inherited, you can always write
ALTER TABLE expenses
PARTITION BY LIST COLUMNS (category)
(
PARTITION p01 VALUES IN ( 'lodging', 'food'),
PARTITION p02 VALUES IN ( 'flights', 'ground transportation'),
PARTITION p03 VALUES IN ( 'leisure', 'customer entertainment'),
PARTITION p04 VALUES IN ( 'communications'),
PARTITION p05 VALUES IN ( 'fees')
);


makes life easy.... :)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: PARTITION BY RANGE (CHARACTER BASIS) ?
2036
April 13, 2010 07:53PM


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.