ERROR 1064 (42000): You have an error in your SQL syntax; checkthe manual that corresponds to your
Fantastic news! We've Found the answer you've been seeking!
Question:
ERROR 1064 (42000): You have an error in your SQL syntax; checkthe manual that corresponds to your MySQL server version for theright syntax to use near 'FOREIGN KEY REFERENCES StuID(StuID) )' atline 5
CREATE TABLE Advisors ( AdvID int NOT NULL PRIMARY KEY, LastNamevarchar(255) NOT NULL, FirstName varchar(255) NOT NULL, StuID intFOREIGN KEY REFERENCES StuID(StuID) );
Posted Date: