MySQL Forums
Forum List  »  Partitioning

Partition by range (Every 500,000 records )
Posted by: arda tunccekic
Date: August 03, 2017 02:32AM

Hi,
I can "alter table" and define partitions by every 500,000 records like:

alter table mytable
partition by range (id)
(
partition p_1 values less than(500000),
partition p_2 values less than(1000000),
...
...
partition p_200 values less than(100000000)
)


Is there a syntax allowing to define partitions for "every 500000 id" until there's no disk space left?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition by range (Every 500,000 records )
161
August 03, 2017 02:32AM


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.