MySQL Forums
Forum List  »  Partitioning

ADD column in Partitioned table
Posted by: kaveen v
Date: November 08, 2017 12:49AM

I have the table with 10 million records and with year partitioned column,
Now I want to add column from next partition set (Ex: 1991).

PARTITION BY RANGE( YEAR(joined) ) (
PARTITION p0 VALUES LESS THAN (1960),
PARTITION p1 VALUES LESS THAN (1970),
PARTITION p2 VALUES LESS THAN (1980),
PARTITION p3 VALUES LESS THAN (1990),
PARTITION p4 VALUES LESS THAN MAXVALUE
);

How to ADD COLUMN which applicable only for a upcoming partition values?

Options: ReplyQuote


Subject
Views
Written By
Posted
ADD column in Partitioned table
1931
November 08, 2017 12:49AM
981
November 08, 2017 10:52AM


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.