In this post, you’ll learn more about the MariaDB Error 1140 ER_MIX_OF_GROUP_FUNC_AND_FIELDS with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1140 – ER_MIX_OF_GROUP_FUNC_AND_FIELDS with the sqlState 42000
Error Description for the MariaDB Error ER_MIX_OF_GROUP_FUNC_AND_FIELDS
Mixing of GROUP columns (MIN(),MAX(),COUNT(),…) with no GROUP columns is illegal if there is no GROUP BY clause