[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

MySQL设置时区时报错：

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated c

导致时区无法修改成功；

解决方法：

• -- 查看sql_mode设置

• show variables like "sql_mode";

• -- 设置sql_mode

• set sql_mode='';

• set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';

再重新执行修改时区sql即可成功修改； 

转载于:https://my.oschina.net/u/3915021/blog/3071184