MySQL error code

MySQL error 1140

MySQL server error 1140 is ER_MIX_OF_GROUP_FUNC_AND_FIELDS, reported with SQLSTATE 42000.

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Error	1140
Name	ER_MIX_OF_GROUP_FUNC_AND_FIELDS
SQLSTATE	42000
Group	Server errors

In other databases