mysql建表date_MYSQL建表报错

CREATETABLECompany.EMPLOYEE(FnameVARCHAR(15)NOTNULL,MinitCHAR,LnameVARCHAR(15)NOTNULL,SsnCHAR(9)NOTNULL,BdateDATE,AddressVARCHAR(30),SexCHAR,SalayDECIMAL(10,2),Super_ssnC...

CREATE TABLE Company.EMPLOYEE

(Fname VARCHAR(15) NOT NULL,

Minit CHAR,

Lname VARCHAR(15) NOT NULL,

Ssn CHAR(9) NOT NULL,

Bdate DATE,

Address VARCHAR(30),

Sex CHAR,

Salay DECIMAL(10,2),

Super_ssn CHAR(9),

Dno INT NOT NULL,

PRIMARY KEY(Ssn),

FOREIGN KEY(Super_ssn) REFERENCES EMPLOYEE(Ssn),

FOREIGN KEY(Dno) REFERENCES DEPARTMENT(Dnumber)

);

*************************************************

错误提示是：

Error Code: 1005. Can't create table 'company.employee' (errno: 150)

求助各位大侠，为什么啊？

我把

FOREIGN KEY(Super_ssn) REFERENCES EMPLOYEE(Ssn),

FOREIGN KEY(Dno) REFERENCES DEPARTMENT(Dnumber)

这连个REFERENCES约束去掉后就能运行了

很奇怪 是为什么呢

展开