MYSQLÈçºÎÌí¼Ó¶à¸öÍâ¼ü£¿

create table Employee
(
ssn INTEGER not null unique,
Name varchar(30) not null,
    Address varchar(30) not null,
    Age INTEGER not null,
Sex varchar(10) not null,
Position varchar(20) not null,
    primary key(ssn)
)ENGINE=InnoDB;


create table Department
(
DId INTEGER not null unique,
    Dname varchar(15) not null,
ManagerId INTEGER not null unique,
    primary key(DId)
);
create table Works_In
(
ssn INTEGER not null unique,
DId INTEGER not null unique,
since varchar(15) not null,
primary key(ssn,DId),
FOREIGN KEY(ssn,DId) REFERENCES Employee(ssn) ON DELETE CASCADE ON UPDATE CASCADE
FOREIGN KEY(DId) REFERENCES Department(DId) ON DELETE CASCADE ON UPDATE CASCADEΪʲô
)ENGINE=InnoDB;
ÔÚWorks_InÖиøEmployeeºÍDepartment¼ÓÁ½¸öÍâ¼ü
ÕâÑùΪʲô²»ÐУ¿
ERROR 1005 (HY000) at line 62: Can't create table './HumanResources/Works_In.frm' (errno: 150)
Ó¦¸ÃÔõôÑùд£¿

---

Ö÷¼üÊÇΨһµÄ£¬²»ÄÜÓÃÁ½¸öµÄ°É, ¶øÇÒÒª·Ç¿Õ¡£

Ö÷¼ü²»ÄÜ×öÍâ¼üʹÓã¡£¡

Â¥Ö÷ȱ·¦sqlµÄ»ù´¡ÖªÊ¶£¬½¨ÒéÈ¥mysqlÍøÕ¾ÉÏ¿´¿´¡£

---

create table Employee
(
ssn INTEGER not null unique,
Name varchar(30) not null,
    Addre