mysql - 为什么我的查询会导致 1064 (42000) 错误？

Question

查询问题，我一生都无法弄清楚这个查询出了什么问题

HAVING distance  ='10'
GROUP BY c.ancient,
   c.ant_name,
   p.upper,
   p.name,

ERROR 1064 (42000): 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 BY c.city_id, c.city_name, p.prop_ynow_id, p.Name, pr.PRE_Ident SELECT dis' at line 1

Answer 1

HAVING 位于 GROUP BY 之后。 MySQL 就是这样挑剔的。