CREATE TABLE Plane
(
regno VARCHAR(8),
make VARCHAR(10),
model VARCHAR(10),
owner VARCHAR(10) NOT NULL,
name VARCHAR(30),
CONSTRAINT Plane_FK FOREIGN KEY (make,model) REFERENCES Planemodel (varchar(10), varchar(10)),
CONSTRAINT Plane_PK PRIMARY KEY (regno)
);
I am trying to make "make" and "model" 2 foreign references that occur in Planemodel. Both are varchar(10)
'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(10), varchar(10)),
CONSTRAINT Plane_PK PRIMARY KEY (regno)
)' at line 8'