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 ')' at line 13
这个我外键我没办法
老是报错
CREATE TABLE employees(
employeeID CHAR(6) PRIMARY KEY,
name CHAR(10) NOT NULL,
education CHAR(4) NOT NULL,
birthday DATE NOT NULL,
sex CHAR(2) NOT NULL DEFAULT 1,
workyear TINYINT(1),
address VARCHAR(20),
phonenumber CHAR(12),
emailaddress VARCHAR(60),
departmentID CHAR(3),
FOREIGN KEY(departmentID) REFERENCES departments(departmentID),
);
这个题题主已解决
倒数第二行没有逗号
先创建外键表