This article is a detailed analysis of the compatibility of MySQL syntax (using count in queries), the need for a friend under the reference
In simple terms, count and more fields are used in queries
Copy Code code as follows:
Select count (ID), id,name from table
It's embarrassing, my environment is 5.5, this is to get the result, but run to the server is not
All right, I made a mistake.
Copy Code code as follows:
#1140-mixing of GROUP columns (MIN (), MAX (), COUNT (),...) with no group columns was illegal if there is no GROUP BY clause
In the 5.x is available, but the value of the other fields is only to get the first message, OK, I admit that this is a partial door to the writing, there is no practical significance, may be a novice's grammatical structure of the idea is not clear.
Well, as a newcomer, I'd be wise to switch over with the WAMP version switch.