MySQL声明不正确
问题描述:
select substring(member.own,3,4), count (*)
from member, amphur
Where amphur.AMPHUR_CODE = substring(member.own,3,4)
group by substring(member.own,3,4)
1064 - 您的SQL语法错误;检查与您的MySQL服务器版本相对应的手册,以便在成员,amphur附近使用*)。amphur.AMPHUR_CODE = substring(member.own,3,4)g'at line 1MySQL声明不正确
答
删除COUNT
和(*)
之间的空格。如果有空间,MySQL不会将“count”识别为函数。
答
SELECT SUBSTRING(m.own,3,4),
COUNT(*) AS cnt
FROM MEMBER AS m,
amphur AS a
WHERE a.AMPHUR_CODE COLLATE utf8_general_ci = SUBSTRING(m.own,3,4)
GROUP BY SUBSTRING(m.own,3,4)
打赌我给它1分钟:-) – rzetterberg 2011-04-10 11:32:06
@tee:您将能够前使用功能,然后空格“(”只有当你设定的sql_mode = IGNORE_SPACE; – 2011-04-10 11:36:49
#1267 - 非法搭配排序规则(utf8_unicode_ci,IMPLICIT)和(utf8_general_ci,IMPLICIT)进行操作'=' – tee 2011-04-10 14:30:15