cucumber Posted May 25, 2007 Report Share Posted May 25, 2007 Vai kaut ko tadu ir iespejams realizet? select 1 as col1, 2 as col2, col1+col2 as sumcol1col2 Link to comment Share on other sites More sharing options...
andrisp Posted May 25, 2007 Report Share Posted May 25, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
cucumber Posted May 25, 2007 Author Report Share Posted May 25, 2007 select @col1 := 1, @col2 := 2, col1+@col2 as sumcol1col2 Jup works, tikai bez sum, jo tur ir "+". Link to comment Share on other sites More sharing options...
andrisp Posted May 25, 2007 Report Share Posted May 25, 2007 Ā, nujā. Link to comment Share on other sites More sharing options...
Recommended Posts