记录下mysql的一次语句运行错误操作,
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX'
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解决方法:在mysql的my.ini配置文件中[mysqld]后面增加 一行
```
sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES
```