mysql有外键时分区出现错误Error Code : 1506_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2195 | 回复: 1

主题： mysql有外键时分区出现错误Error Code : 1506

zlasdf

注册用户

等级：新兵
经验：72
发帖：70
精华：0
注册：2011-10-17
状态：离线
发送短消息息给zlasdf

加好友发送短消息息给zlasdf

发消息

发表于：

2015-2-9 11:50:57 | [全部帖] [楼主帖]

楼主

mysql 版本：5.5.8

建表sql如下：

DROP TABLE IF EXISTS `xmldata`;CREATE TABLE `xmldata` (
`XmlDataId` INT(11) NOT NULL AUTO_INCREMENT,
`XmlDocId` INT(11) NOT NULL,
`XmlTagId` INT(11) NOT NULL,
`TagValue` VARCHAR(10000) DEFAULT NULL,
`ContentWhUrl` VARCHAR(2000) DEFAULT NULL,
`ParentId` INT(11) NOT NULL,
PRIMARY KEY (`XmlDataId`),
KEY `Fk_XmlTag_XmlTag_XmlTagId` (`XmlTagId`),
KEY `Fk_XmlTag_XmlDoc_XmlDocId` (`XmlDocId`),
CONSTRAINT `Fk_XmlTag_XmlTag_XmlTagId` FOREIGN KEY (`XmlTagId`) REFERENCES `xmltag` (`XmlTagId`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `Fk_XmlTag_XmlDoc_XmlDocId` FOREIGN KEY (`XmlDocId`) REFERENCES `xmldoc` (`XmlDocId`) ON DELETE CASCADE ON UPDATE CASCADE
)

ENGINE=INNODB AUTO_INCREMENT=1220861 DEFAULT CHARSET=utf8 COMMENT='保存xml的具体内容'

PARTITION BY RANGE(XmlDataId)(
PARTITION P0 VALUES LESS THAN (500000),
PARTITION P1 VALUES LESS THAN (1000000),
PARTITION P2 VALUES LESS THAN (1500000),
PARTITION P3 VALUES LESS THAN (2000000),
PARTITION P4 VALUES LESS THAN (2500000),
PARTITION P5 VALUES LESS THAN MAXVALUE
)

;出现错误：

Error Code : 1506

Foreign key clause is not yet supported in conjunction with partitioning请问要如何解决？谢谢！

--转自