check the manual that corresponds to your MySQL server version for the right 问题询问

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


img


就是这个外键不会搞,另外不知道有没有其他的问题
就上面一个报错

img


我按着网上的方法填的倒数第二行

这个题题主已解决
倒数第二行没有逗号
先创建外键表