MySQL Forums
Forum List  »  Partitioning

How to divide the table into 1000 part
Posted by: oto shavadze
Date: February 06, 2012 01:07AM

Hello
There is a table, into the table is a field id.
It is expected that, in this table awaken 1 billion REC.
I want to divide (through partition) this table so that:
Everi part contained one million REC.
I make this so:

PARTITION BY RANGE(id) (
PARTITION p_1 VALUES LESS THAN(1000000),
PARTITION p_2 VALUES LESS THAN(2000000),
PARTITION p_3 VALUES LESS THAN(3000000),
.................
...........


But, I have done this 1000 times by hand.
Question: This is single variant?
There is no way to do this automatically?
Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to divide the table into 1000 part
3252
February 06, 2012 01:07AM


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.