MySQL Forums
Forum List  »  Partitioning

Partitioning tables with grouping
Posted by: sonam agarwal
Date: April 10, 2010 07:31AM

Could somebody help me in solving the following issue?

I need to partition my table based on the following conditions :

1) The table has a number of clients
2) I wish to keep the data of one particular client into one partition.
3) This data includes a number of records for each client

Basically, i want to group the records particular to one client as one partition. How can i achieve this? Does MySQL support this? Please do help at the earliest.

Options: ReplyQuote

Written By
Partitioning tables with grouping
April 10, 2010 07:31AM

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.