MySQL Forums
Forum List  »  Partitioning

Re: After partition, query returns wrong result.
Posted by: yansheng lin
Date: May 19, 2006 12:30PM

This is the CREATE TABLE statement.

CREATE TABLE `books` (
`department_id` int(10) unsigned NOT NULL default '0',
`book_id` int(10) unsigned NOT NULL default '0',
`session_count` decimal(38,0) NOT NULL default '0',
`log_hour` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`department_id`,`book_id`,`log_hour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE (YEAR(log_hour)*100+MONTH(log_hour)) (PARTITION p1 VALUES LESS THAN (200605) ENGINE = MyISAM, PARTITION p2 VALUES LESS THAN (200606) ENGINE = MyISAM, PARTITION p3 VALUES LESS THAN (200607) ENGINE = MyISAM, PARTITION p4 VALUES LESS THAN (200608) ENGINE = MyISAM, PARTITION p5 VALUES LESS THAN (200609) ENGINE = MyISAM, PARTITION p6 VALUES LESS THAN (200610) ENGINE = MyISAM, PARTITION p7 VALUES LESS THAN (200611) ENGINE = MyISAM, PARTITION p8 VALUES LESS THAN (200612) ENGINE = MyISAM, PARTITION p9 VALUES LESS THAN (200701) ENGINE = MyISAM, PARTITION p10 VALUES LESS THAN (200702) ENGINE = MyISAM, PARTITION p11 VALUES LESS THAN (200703) ENGINE = MyISAM, PARTITION p12 VALUES LESS THAN (200704) ENGINE = MyISAM, PARTITION p13 VALUES LESS THAN (200705) ENGINE = MyISAM, PARTITION p14 VALUES LESS THAN MAXVALUE ENGINE = MyISAM);

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: After partition, query returns wrong result.
2264
May 19, 2006 12:30PM


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.