ErrorNo 150 mySQL

Question

I have this problem when I try to create two foreign key in the same table how I can fix it & thank you

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

Your FOREIGN KEY syntax looks off to me, and I don't know why you wrap the definition in workat. Try this version:

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) 
);

Here is a demo showing that your code compiles after making the above changes:

Demo