mysql - 错误 1064 MySQL 错误

Question

这个问题已经有答案了:

Syntax error due to using a reserved word as a table or column name in MySQL (1 个回答)

已关闭 7 年前。

CREATE TABLE references ( hamsterId MEDIUMINT(9), id MEDIUMINT(9), complete BINARY(1));

我一直在运行错误消息，我尝试了很多可能性，但没有得到答案，谢谢您的帮助!BINARY(1) 是否正确，仅允许 1 或 0 津贴。顺便说一句，这是错误消息:

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 ( hamsterId MEDIUMINT(9), id MEDIUMINT(9), complete BINARY(1))' at line 1

Answer 1

使用 backtics 作为保留名称 REFERENCES 是 mysql 的反转词，请参阅 https://dev.mysql.com/doc/refman/5.7/en/keywords.html

 CREATE TABLE `references` ( hamsterId MEDIUMINT(9), id MEDIUMINT(9), complete BINARY(1));