mysql - SQL 查询 : join two tables

Question

所以我在这个 sql 查询中得到一个错误，但我自己看不到我的错误:

SELECT group_members.group_id, 
       group_members.permissions, 
       group.group_name
  FROM group_members, 
       group 
 WHERE group_members.group_id=group.group_id
   AND group.group_id = 1

错误:

#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 'group WHERE group_members.group_id=group.group_id AND group.group_id = 1

感谢您的帮助!

Answer 1

Group 是 MySQL 中的保留字，要么将其括在反引号“`”中，要么最好不要将其用作表名

SELECT group_members.group_id, group_members.permissions, `group`.group_name
FROM group_members, `group` 
WHERE group_members.group_id=`group`.group_id
AND `group`.group_id = 1