Question

我正试图把一笔钱的产物储存在一个变数中,然后在 que中使用,但迄今没有成功。

I ve tried that and it worked just like I expected : SELECT @pos := titi "c1", @pos "c2";

titi | titi

When I try to do it with a group by function it just doesn t work anymore, it sets my variable to the last processed function.

SELECT c1, @titi := SUM(c2), @titi FROM (SELECT 1 "c1",2 "c2" UNION SELECT 2,3 UNION SELECT 1,4) t GROUP BY c1;

www.un.org/Depts/DGACM/index_russian.htm

页: 1

2 P-4, 3 P-3, 3 FS, 3 NS

www.un.org/Depts/DGACM/index_russian.htm

页: 1

2 P-4, 3 P-3, 3 FS, 3 NS

我能做些什么来使变量保持其价值不变?

Answer 1

如果我正确回顾,这里的问题是,处理小组第一行时,不包含聚合功能的一栏的价值就算出,而转让编号为@var:=SUM。计算总价值时发生。

或者,如果合并的职能相当复杂,那么你要么需要重复合并职能,要么不需要重复:a)把一切放在分局,b)使用诸如<条码>(COUNT(*), @var, @var)(看上去的是黑板)等东西。

P.S. 您的询问似乎无效,因为用背书引述了栏名。