mysql求助 150 错误 1005 - Can't create table '.\business\epost.frm' (errno: 150)
CREATETABLE`epost`(`eno`bigint(10)NOTNULL,`pno`int(11)NOTNULL,PRIMARYKEY(`eno`,`pno`)...
CREATE TABLE `epost` (
`eno` bigint(10) NOT NULL,
`pno` int(11) NOT NULL,
PRIMARY KEY (`eno`,`pno`),
KEY `FK_EP_PNO` (`pno`),
CONSTRAINT `FK_EP_ENO` FOREIGN KEY (`eno`) REFERENCES `emp` (`eno`),
CONSTRAINT `FK_EP_PNO` FOREIGN KEY (`pno`) REFERENCES `post` (`pno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected
1005 - Can't create table '.\business\epost.frm' (errno: 150)
这是报错信息 , 求助 怎么解决? 展开
`eno` bigint(10) NOT NULL,
`pno` int(11) NOT NULL,
PRIMARY KEY (`eno`,`pno`),
KEY `FK_EP_PNO` (`pno`),
CONSTRAINT `FK_EP_ENO` FOREIGN KEY (`eno`) REFERENCES `emp` (`eno`),
CONSTRAINT `FK_EP_PNO` FOREIGN KEY (`pno`) REFERENCES `post` (`pno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected
1005 - Can't create table '.\business\epost.frm' (errno: 150)
这是报错信息 , 求助 怎么解决? 展开
1个回答
2013-03-27
展开全部
primary key是主键。主键只能有一个、
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询