Error 1140: Mixing of GROUP columns with no GROUP columns
Error Code
SQLSTATE
Error
Description
1140
42000
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
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1139: Got error from regexpNextError 1141: There is no such grant defined for user on host
Last updated
Was this helpful?