为啥我这个有语法错误

Question

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 '

asalary decimal(65),
coname varchar(200),
FOREIGN KEY (coname) R' at line 2

CREATE TABLE league(

lname varchar(200) PRIMARY,
asalary decimal(65),
coname varchar(200),
FOREIGN KEY (coname) REFERENCES country(coname));

CREATE TABLE country(
coname varchar(200));

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 '

asalary decimal(65),
coname varchar(200),
FOREIGN KEY (coname) R' at line 2

改变变量名称

可以达到关联

Answer 1

你这个建表的脚本不全，发一发完整脚本出来。