![Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxxx_51CTO博客_expression: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxxx_51CTO博客_expression:](https://s2.51cto.com/images/blog/202206/22100630_62b279266b94432848.png?x-oss-process=image/watermark,size_16,text_QDUxQ1RP5Y2a5a6i,color_FFFFFF,t_30,g_se,x_10,y_10,shadow_20,type_ZmFuZ3poZW5naGVpdGk=)
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxxx_51CTO博客_expression:
![sql-mode="STRICT_TRANS_TABLES ,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"问题解决_weixin_30788731的博客-CSDN博客 sql-mode="STRICT_TRANS_TABLES ,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"问题解决_weixin_30788731的博客-CSDN博客](https://images0.cnblogs.com/blog2015/608161/201506/120837437855755.jpg)
sql-mode="STRICT_TRANS_TABLES ,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"问题解决_weixin_30788731的博客-CSDN博客
Make Piwik compatible with sql_mode = STRICT_TRANS_TABLES (MySQL 5.6 default and best practise) · Issue #5178 · matomo-org/matomo · GitHub
![unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES'_51CTO博客_unknown variable datadir unknown variable 'sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES'_51CTO博客_unknown variable datadir](https://s2.51cto.com/wyfs02/M02/9E/36/wKiom1mMn3mC_J_nAADk4xbe0AY933.jpg)