Mysql新建表

Question

我对我的表有一些疑问

    CREATE TABLE user_roles(
    user_role_id int(10) unsigned not null, 
    user_id int(10) unsigned not null, 
    authority varchar(45) not null, 
    PRIMARY KEY(user_role_id), 
    KEY FK_user_roles (user_id), 
    CONSTRAINT FK_user_roles FOREING KEY (user_id) REFERENCES users (user_id)) 
ENGINE=InnoDB DEFAULT CHARSET=utf8;

我收到以下错误:

    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 
'FOREING KEY (user_id) REFERENCES users (user_id)) ENGINE=InnoDB DEFAULT CHARSET=' at line 7

Answer 1

简单的错误

外国不是外国