文档解释
Error number: 3065; Symbol: ER_FIELD_IN_ORDER_NOT_SELECT; SQLSTATE: HY000
Message: Expression #%u of ORDER BY clause is not in SELECT list, references column ‘%s’ which is not in SELECT list; this is incompatible with %s
。
错误说明：将一个字段放在ORDER BY子句中但该字段未在SELECT子句中选择时可能引发MySQL的ER_FIELD_IN_ORDER_NOT_SELECT错误。
常见案例
SELECT id
FROM products
ORDER BY name
如果客户端尝试执行上述查询，MySQL将报告ER_FIELD_IN_ORDER_NOT_SELECT错误，因为ORDER BY子句中的name字段没有在SELECT子句中选择。
解决方法：要修复此错误，请确保ORDER BY子句中的字段在SELECT子句中被选择。在上面的案例中，需要将name字段添加到SELECT子句中：
SELECT id, name
FROM products
ORDER BY name
