MySQL Forums
Forum List  »  Partitioning

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

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?


Options: ReplyQuote

Written By
Partition by range (Every 500,000 records )
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.