MySQL Forums :: Partitioning :: partioning question


Advanced Search

partioning question
Posted by: asmaa atef ()
Date: May 23, 2009 05:56AM

Hello every one,
i want to ask about partioning
suppose this create statement
CREATE TABLE members (
firstname VARCHAR(25) NOT NULL,
lastname VARCHAR(25) NOT NULL,
username VARCHAR(16) NOT NULL,
email VARCHAR(35),
joined DATE NOT NULL
)
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
);

i want to know what is meant by partition p0 ,p1,...
and if is they repesent a physical storage or what?
and what is the step that precede creating the table to make partioning
i need an answer for this necessary and thanks in advance.
asmaa

Options: ReplyQuote


Subject Views Written By Posted
partioning question 3833 asmaa atef 05/23/2009 05:56AM
Re: partioning question 2669 Rick James 05/24/2009 09:29AM
Re: partioning question 2724 asmaa atef 05/27/2009 03:17AM
Re: partioning question 2526 Rick James 05/27/2009 09:50AM
Re: partioning question 2466 asmaa atef 05/28/2009 05:53AM
Re: partioning question 2099 Rick James 05/29/2009 12:36AM
Re: partioning question 2579 asmaa atef 05/29/2009 08:39AM
Re: partioning question 2487 Rick James 05/29/2009 10:49AM
Re: partioning question 2406 asmaa atef 05/31/2009 08:10AM
Re: partioning question 2504 Rick James 05/31/2009 12:11PM
Re: partioning question 2556 asmaa atef 06/03/2009 04:16AM
Re: partioning question 2504 Rick James 06/03/2009 11:20PM


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.