【原创】【AZ核心模块】玩家排名模块（2020-6月份版本AZ）

caesarlonely

这个模组好玩，加程序里试试

hjwade

报错SQL: replace into gb_player_rank(Account,PlayerName, RankValue,RankType) select b.account, b.`name`,sum(achievementpoint) as points,'成就' from  335c.character_achievement a inner join 335c.characters b on a.guid = b.guid inner join 335w.dbc_Achievement c on a.achievement = c.achievementid GROUP BY b.`name`order by points desc;
ERROR: [1055] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '335c.b.account' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Unhandled MySQL errno 1055. Unexpected behaviour possible.

youai520

感谢大神奉献

纠察大队长

谢谢大佬分享 学习了  借鉴下

纠察大队长

为什么用21年的az编译出现错误2001

tiancailwm

感谢分享！

纠察大队长

4821292 发表于 2022-3-5 09:09
为什么用21年的az编译出现错误2001

找到原因了 字的问题- -

a347002368

干货  学习学习