A brief analysis of compatibility issues with a MySQL syntax (using count in queries)

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.