mysql - mysql有问题，不允许多个外键

Question

我的数据库中有三个表

书籍（桌）

create table books (book_id int auto_increment, bookName varchar(10), qty int,primary key(book_id));

学生（桌）

create table students (student_id int auto_increment,studentName varhchar(10),primary key(student_id));

已发行图书（表）

create table issuedBooks(book_id int ,student_id int ,issued_date date, foreign key (book_id) references books(book_id), foreign key (students) references students(student_id));

mysql报错说

ERROR 1064 (42000): 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 'references students(student_id))' at line 1

当我删除第二个外键时，它可以工作。我不明白我做错了什么？

工作（没有任何错误，我刚刚删除了第二个外键）

create table issuedBooks(book_id int ,student_id int,issued_date date, foreign key (book_id) references books(book_id)); 

标签： mysql