本地架设问题..

  1. 4 周前
    4 周前,由 ins 重新编辑

    在本地架设,各项输入完点确定后出现
    数据库语法问题,求帮忙..感激
    07_57_32_image.png

    SQL Error (42000, 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, GROUP_CONCAT(g.name) AS groupNames, BIT_OR(g.canSuspend) AS canSuspe' at line 2
    
    SELECT m.*, 
    	GROUP_CONCAT(g.groupId) AS groups, 
    	GROUP_CONCAT(g.name) AS groupNames, 
    	BIT_OR(g.canSuspend) AS canSuspend
    FROM `et_member` m
    	LEFT JOIN `et_member_group` mg ON (mg.memberId=m.memberId)
    	LEFT JOIN `et_group` g ON (g.groupId=mg.groupId)
    WHERE (m.memberId=1)
    GROUP BY m.memberId
    

或者 注册后参与话题.