菜鸟国际电子游戏首页 > 文章中心 > 正文

this is incompatible with sql-电子游戏app下载


[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  


电子游戏app下载的解决方案::
select version(),
@@sql_mode;set sql_mode=(select replace(@@sql_mode,'only_full_group_by',''));
完美解决::
show variables like "sql_mode";
set sql_mode='';
set sql_mode='no_engine_substitution,strict_trans_tables';
或者配置文件:
sql-mode="strict_all_tables,error_for_division_by_zero,no_zero_date,no_zero_in_date,no_auto_create_user"

转载请注明出处:

0

相关文章