MySQL 出现 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
第一步:
show variables like "sql_mode";
第二步:
set sql_mode='';
第三步:
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';
MySQL 出现 [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause 的问题
第一步:
show variables like "sql_mode";
第二步:
set sql_mode='';
第三步:
set sql_mode='NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES';