标题: mysql 分区表的问题----问题解决。。。 [打印本页] 作者: babyyellow 时间: 2007-07-23 15:08 标题: mysql 分区表的问题----问题解决。。。 CREATE TABLE `bbs_article` (
`bbs_article_id` DECIMAL(22, 0) NOT NULL,
`bbs_topic_id` DECIMAL(22, 0) NULL,
`use_html` DECIMAL(22, 0) NULL,
`content0` VARCHAR(255) BINARY NULL,
`client_ip` VARCHAR(255) BINARY NULL,
`author_id` DECIMAL(19, 0) NULL,
`author_name` VARCHAR(255) BINARY NULL,
`content1` DECIMAL(22, 0) NULL,
`create_time` DATETIME NULL,
`edit_count` DECIMAL(22, 0) NULL,
`floor` DECIMAL(22, 0) NULL,
`bbs_forum_id` DECIMAL(22, 0) NULL,
`last_modifier_id` DECIMAL(19, 0) NULL,
`last_update` DATETIME NULL,
`status` DECIMAL(22, 0) NULL,
`to_floor` DECIMAL(22, 0) NULL,
`jdo_version` DECIMAL(22, 0) NOT NULL,
PRIMARY KEY (`bbs_article_id`)
)
PARTITION BY RANGE (BBS_ARTICLE_ID)
(
PARTITION P1 VALUES LESS THAN (800000),
PARTITION P2 VALUES LESS THAN (1600000),
PARTITION P3 VALUES LESS THAN (2400000),
PARTITION P4 VALUES LESS THAN (3800000),
PARTITION P5 VALUES LESS THAN (5500000),
PARTITION P6 VALUES LESS THAN (7000000),
PARTITION P7 VALUES LESS THAN (8500000),
PARTITION P8 VALUES LESS THAN (9700000),
PARTITION P9 VALUES LESS THAN (11000000),
PARTITION P10 VALUES LESS THAN (12200000),
PARTITION P11 VALUES LESS THAN (13500000),
PARTITION P12 VALUES LESS THAN (14500000),
PARTITION P13 VALUES LESS THAN (16700000),
PARTITION P14 VALUES LESS THAN (17500000),
PARTITION P15 VALUES LESS THAN (18400000),
PARTITION P16 VALUES LESS THAN (19300000),
PARTITION P17 VALUES LESS THAN (20300000),
PARTITION P18 VALUES LESS THAN (21300000),
PARTITION P19 VALUES LESS THAN (22300000),
PARTITION P20 VALUES LESS THAN (23300000),
PARTITION P21 VALUES LESS THAN (24300000),
PARTITION P22 VALUES LESS THAN (25500000),
PARTITION P25 VALUES LESS THAN (MAXVALUE)
)
MYSQL 5。1。20
建立分区表的时候，不成功。
报错
ERROR 1488 (HY000): The PARTITION function returns the wrong type
mysql>
-------------------------------
把DECIMAL 不支持分区关键字
[ 本帖最后由 babyyellow 于 2007-7-23 15:58 编辑 ]作者: beyond_dream 时间: 2007-08-20 00:12
CREATE TABLE `bbs_article` (
`bbs_article_id` int(22) NOT NULL,
`bbs_topic_id` DECIMAL(22, 0) NULL,
`use_html` DECIMAL(22, 0) NULL,
`content0` VARCHAR(255) BINARY NULL,
`client_ip` VARCHAR(255) BINARY NULL,
`author_id` DECIMAL(19, 0) NULL,
`author_name` VARCHAR(255) BINARY NULL,
`content1` DECIMAL(22, 0) NULL,
`create_time` DATETIME NULL,
`edit_count` DECIMAL(22, 0) NULL,
`floor` DECIMAL(22, 0) NULL,
`bbs_forum_id` DECIMAL(22, 0) NULL,
`last_modifier_id` DECIMAL(19, 0) NULL,
`last_update` DATETIME NULL,
`status` DECIMAL(22, 0) NULL,
`to_floor` DECIMAL(22, 0) NULL,
`jdo_version` DECIMAL(22, 0) NOT NULL,
PRIMARY KEY (`bbs_article_id`)
)
PARTITION BY RANGE (bbs_article_id)
(
PARTITION P1 VALUES LESS THAN (800000),
PARTITION P2 VALUES LESS THAN (1600000),
PARTITION P3 VALUES LESS THAN (2400000),
PARTITION P4 VALUES LESS THAN (3800000),
PARTITION P5 VALUES LESS THAN (5500000),
PARTITION P6 VALUES LESS THAN (7000000),
PARTITION P7 VALUES LESS THAN (8500000),
PARTITION P8 VALUES LESS THAN (9700000),
PARTITION P9 VALUES LESS THAN (11000000),
PARTITION P10 VALUES LESS THAN (12200000),
PARTITION P11 VALUES LESS THAN (13500000),
PARTITION P12 VALUES LESS THAN (14500000),
PARTITION P13 VALUES LESS THAN (16700000),
PARTITION P14 VALUES LESS THAN (17500000),
PARTITION P15 VALUES LESS THAN (18400000),
PARTITION P16 VALUES LESS THAN (19300000),
PARTITION P17 VALUES LESS THAN (20300000),
PARTITION P18 VALUES LESS THAN (21300000),
PARTITION P19 VALUES LESS THAN (22300000),
PARTITION P20 VALUES LESS THAN (23300000),
PARTITION P21 VALUES LESS THAN (24300000),
PARTITION P22 VALUES LESS THAN (25500000),
PARTITION P25 VALUES LESS THAN MAXVALUE
)
帮你改了第2行 `bbs_article_id` int(22) NOT NULL,
第21行 PARTITION BY RANGE (bbs_article_id)