Shulou(Shulou.com)06/02 Report--

Mysql5.7 in the use of group by error report how to solve, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Error message:

SELECT list is not in GROUP BY clause and contains nonaggregated column

Use the command:

SHOW GLOBAL VARIABLES

Check to see that only_full_group_by is included in the value of sql_mode and delete it:

Is it helpful for set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.