### 報錯信息 ``` # SQLSTATE\[42000\]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wanlshop.wan\_pull\_log.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by ``` ###在mysql的ini配置文件中[mysqld]添加下面的一行 ### mysql5.7版本以上會出現問題 , 5.6不會 ``` [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES ```