mysql - 修改表错误:150

Question

我无法更改表来添加外键。错误:150 出现。无法弄清楚出了什么问题。请帮忙

CREATE TABLE Staff (staffNo varchar(10) NOT NULL, Fname varchar(50),
Lname varchar(50), Staff_Adress varchar(100), Salary numeric(65),
JobPosition varchar(15), Sex varchar(1), DateOfBirth date, NIN varchar(25),OffceNo varchar(10),
PRIMARY KEY (staffNo),
CHECK (Sex IN ('M', 'F')));

CREATE TABLE Office (OfficeNo INT(10) unsigned NOT NULL, Address varchar(50) NOT NULL, City varchar (25) NOT NULL,
PhoneNo varchar(10) NOT NULL, ManagerNo varchar(10),
PRIMARY KEY (OfficeNo),
FOREIGN KEY (ManagerNo) references  Staff(staffNo));

alter table Staff
add foreign key (OffceNo) references Office(OfficeNo) on delete set NULL;

Answer 1

解决这些问题:

1. 表必须使用 InnoDB
2. 列必须具有完全相同的数据类型