Re: PARTITION BY RANGE (CHARACTER BASIS) ?

[sonam agarwal]

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.... :)