MySQL语法错误，无法弄清楚是什么问题

Question

您好，感谢阅读我的问题!我收到此代码的语法错误，但我无法弄清楚出了什么问题。非常感谢任何见解。

mysql> create table match (
-> event_id int not null,
-> player1_id int,
-> player2_id int,
-> player1_score int,
-> player2_score int,
-> winner_id int,
-> foreign key (event_id) references event(id)
-> );
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 'match (
event_id int not null,
player1_id int,
player2_id int,
player1_score int' at line 1

我找不到任何遗漏的逗号，而且事件表肯定存在一个 id 列。有什么想法我想念的吗？谢谢!

Answer 1

匹配是 reserved word .用反引号括起来:

create table `match` ...