mysql - 错误号 150 mySQL

Question

当我尝试在同一个表中创建两个外键时遇到此问题 我该如何解决它&谢谢你

create table employee(
employeeNumber INT (11) primary key,

);


create table projects(

projectNumber INT(11) primary key ,

);

create table workat(
wemployeeNumber INT(11),
wprojectNUmber INT (11),
primary key (wemployeeNumber,wprojectNUmber),    
FOREIGN key workat(wemployeeNumber) references employee(employeeNumber), 
FOREIGN key workat(wprojectNUmber) references projects(projectNumber) 

);

Answer 1

您的 FOREIGN KEY 语法对我来说很奇怪，我不知道为什么您将定义包装在 workat 中。试试这个版本:

CREATE TABLE workat (
    wemployeeNumber INT(11),
    wprojectNUmber INT(11),
    PRIMARY KEY (wemployeeNumber, wprojectNumber),    
    FOREIGN KEY (wemployeeNumber) REFERENCES employee (employeeNumber), 
    -- projects, not project
    FOREIGN KEY (wprojectNUmber)  REFERENCES projects (projectNumber) 
);

这是一个演示，显示您的代码在进行上述更改后可以编译:

Demo