Sum pec pasa selecta kolonam

[cucumber]

Vai kaut ko tadu ir iespejams realizet?

select 1 as col1, 2 as col2, col1+col2 as sumcol1col2

[andrisp]

select @col1 := 1, @col2 := 2, sum(@col1+@col2) as sumcol1col2

 

http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

Edited May 25, 2007 by andrisp

[cucumber]

select @col1 := 1, @col2 := 2, col1+@col2 as sumcol1col2

Jup works, tikai bez sum, jo tur ir "+".

[andrisp]

Ā, nujā.