mssql 可以用
select @sumtimes=isnull(sum(times),0) ,
@sumprofit=isnull(sum(storefare),0) - isnull(sum(maxfare) ,0) ,
@sumplayerfare=isnull(sum(playerfare),0)
from tgameinfo这样的语句通过一个select给三个变量赋值!
mysql怎么写呢?
我只知道一个的时候用set abc=(select sum(times) from tgameinfo);
赋值多变量就补知道了!
select @sumtimes=isnull(sum(times),0) ,
@sumprofit=isnull(sum(storefare),0) - isnull(sum(maxfare) ,0) ,
@sumplayerfare=isnull(sum(playerfare),0)
from tgameinfo这样的语句通过一个select给三个变量赋值!
mysql怎么写呢?
我只知道一个的时候用set abc=(select sum(times) from tgameinfo);
赋值多变量就补知道了!
@sumprofit:=ifnull(sum(storefare),0) - ifnull(sum(maxfare) ,0) ,
@sumplayerfare:=ifnull(sum(playerfare),0)
from tgameinfo
和select count(1) into @cnt from tablename
是等价的 。