My sql 运行的。提醒错误不知道怎么解决

mysql> create table sc(sno char(5) not null constraint S_F FOREIGN KEY REFERENCES S(sno),cno char(2) not null,grade smallint check((grade is null) or (grade between 0 and 100)),primary key(sno,cno),constraint C_F FOREIGN KEY (cno) references course(cno));
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 'FOREIGN KEY REFERENCES S(sno),cno char(2) not null,grade smallint check((grade i' at line 1

create table sc(sno char(5) not null constraint S_F FOREIGN KEY REFERENCES S(sno),cno char(2) not null,grade smallint check((grade is null) or (grade between 0 and 100)),primary key(sno,cno),constraint C_F FOREIGN KEY (cno) references course(cno));
是不是少了参数

img

img