mysql - 无法在mysql中选择表

Question

这是 mysql 表:

+---------------------+

| Tables_in_myproject |

+---------------------+

| reds                |

| zxy                 |

| abcd                |

| release             |

+---------------------+

一组 4 行(0.46 秒)

当我尝试选择或显示发布表时，它会抛出以下错误:

mysql> select * from release;

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 'release' at line 1

我做错了什么？我可以选择所有其他表。

Answer 1

release 是 reserved keyword in MySQL需要用反引号转义。

select * from `release`;