想进行update操作,报了这样一个错:
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
那我想,就不update了,直接delete。没想到也是一样的,看来我非要面对这个问题。
那就上Linux!
1、登录服务器的MySQL:
whereis mysql
/usr/mysql/bin -u root -p
2、查看sql_mode是不是有ONLY_FULL_GROUP参数:
show variables like '%sql_mode%';
3、改掉它!
vim /etc/my.cnf