Analysis on the compatibility of a MYSQL syntax (using count in queries)

Simply put, you can use count and more fields in the query.
Copy codeThe Code is as follows:
Select count (id), id, name from table

It's embarrassing. My environment is 5.5, and the results can be obtained, but it won't work if I run it on the server.
Okay, an error is reported.
Copy codeThe Code is as follows:
#1140-Mixing of GROUP columns (MIN (), MAX (), COUNT (),...) with no GROUP columns is illegal if there is no group by clause

In step 5. x can be used, but the values of other fields only obtain the first piece of information. Well, I admit that this is a partial method and has no practical significance, it may be caused by a new beginner's unclear syntax structure.
Well, as a newbie, I am still wise to use the WAMP version switch function to switch over.