MySQL Forums
Forum List  »  Chinese

Re: NOTE: This version of translation beyond MySQL's control
Posted by: Lu Tao
Date: July 14, 2006 11:55PM

I think MySQL.com should keep the Chinese version updating with the English version.

For an example
In 5.1.7
Names of subpartitions must be unique within each partition, but do not have to be unique within the table as a whole. For example, the following CREATE TABLE statement is valid:

CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s0,
SUBPARTITION s1
)
);

and In 5.1.11
In MySQL 5.1.7 and earlier, names of subpartitions must be unique within each partition, but do not have to be unique within the table as a whole. Beginning with MySQL 5.1.8, subpartition names must be unique across the entire table. For example, the following CREATE TABLE statement is valid in MySQL 5.1.8 and later:

CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY RANGE( YEAR(purchased) )
SUBPARTITION BY HASH( TO_DAYS(purchased) ) (
PARTITION p0 VALUES LESS THAN (1990) (
SUBPARTITION s0,
SUBPARTITION s1
),
PARTITION p1 VALUES LESS THAN (2000) (
SUBPARTITION s2,
SUBPARTITION s3
),
PARTITION p2 VALUES LESS THAN MAXVALUE (
SUBPARTITION s4,
SUBPARTITION s5
)
);

(The previous statement is also valid for versions of MySQL prior to 5.1.8.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: NOTE: This version of translation beyond MySQL's control
4151
July 14, 2006 11:55PM
4415
July 29, 2006 11:01AM


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.