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

Cause of error: mysql version 5.7 and above default sql configuration: sql_mode contains "ONLY_FULL_GROUP_BY" this configuration strictly complies with the "SQL92 standard". Therefore, the upgrade of the database may cause the local sql execution error. Solution: 1. Optimize sql to make it conform to SQL92 Standard 2. Remove the configuration of "ONLY_FULL_GROUP_BY" 1. View the sql_model statement select @ @ GLOBAL.sql_mode Temporarily remove ONLY_FULL_GROUP_BY set @ @ GLOBAL.sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION permanently remove ONLY_FULL_GROUP_BY and modify mysql configuration file. My.cnf is located in the etc folder. Add sql_mode under vim as follows: restart the mysql service after the modification of sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION is completed.

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.