IFNULL( tb.lookback_time,0) as lookback_time
IFNULL(u.nick,concat('userName[',LPAD(u.id,11,0),']')) nick,
CONVERT(ifnull(sum(gp.price),0), SIGNED)
mysql IFNUll+leftpad
最新推荐文章于 2021-11-01 23:08:38 发布
IFNULL( tb.lookback_time,0) as lookback_time
IFNULL(u.nick,concat('userName[',LPAD(u.id,11,0),']')) nick,
CONVERT(ifnull(sum(gp.price),0), SIGNED)