MySQL 5.5不正确的语法

Question

嘿，我不能让这个案例陈述起作用，有人介意告诉我这个语法有什么问题吗？

SELECT standards.standard_id, standards.title, standards.level,standards.credits, SUM(standards.credits), standards.assessment 

CASE  WHEN standards.assessment = 1 THEN 'External' ELSE 'Internal' END CASE
FROM standards JOIN courses_standards ON standards.standard_id = courses_standards.standard_id 
WHERE courses_standards.course_id = 1

确切的错误是：

1064 -您的SQL语法有错误；请检查与您的MySQL服务器版本对应的手册，以获得正确的语法，以便在第3行使用接近“standards.assessment =1，然后”standards.assessment=1“内部”结束的情况下的正确语法。

Answer 1

关于如何结束您的情况，有一个语法错误。当你结束案子的时候你需要提供一个别名。

SELECT standards.standard_id, standards.title, standards.level,standards.credits, SUM(    standards.credits), standards.assessment, 

CASE  WHEN standards.assessment = 1 THEN 'External' ELSE 'Internal' END assessment
FROM standards JOIN courses_standards ON standards.standard_id = courses_standards.    standard_id 
WHERE courses_standards.course_id = 1

Answer 2

你错过了standards.assessment和CASE之间的逗号