MySQL“简单"错误理解 [英] MySQL "simple" error understanding
问题描述
我有一个非常简单的请求:
SELECT * FROM 玩家;
它可以工作并显示玩家"列表.现在,如果我在名为groups"的表上执行完全相同的请求,则会出现语法错误
SELECT * FROM 组;
<块引用>
错误代码:1064.您的 SQL 语法有错误;检查与您的 MySQL 服务器版本相对应的手册,以获取在第 1 行 0.000 秒附近使用组"的正确语法
如果我这样做:
SELECT * FROM mydb.groups;
它有效如果我这样做:
SELECT * FROM `groups`;
它也有效.
GROUPS 是保留关键字(GROUPS (R) 在 8.0.2 (reserved) 中添加):
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-G
i have a very simple request :
SELECT * FROM players;
which works and show a list of "players". Now if i do the exact same request on my table named "groups" i get a syntax error
SELECT * FROM groups;
Error Code: 1064. 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 'groups' at line 1 0.000 sec
If I do :
SELECT * FROM mydb.groups;
It works and if I do :
SELECT * FROM `groups`;
It works too.
GROUPS is a reserved keywords (GROUPS (R) added in 8.0.2 (reserved)) :
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-G
这篇关于MySQL“简单"错误理解的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!