SELECT IFNULL(TRUNCATE(tudi,2),0.00) AS tudigongxian,
IFNULL(TRUNCATE(youhuijing,2),0.00) AS youhuijing,
IFNULL(TRUNCATE(choujiang,2),0.00) AS drawMoney,
IFNULL(TRUNCATE(tixian,2),0.00) AS tixian, u.tel AS tel,u.headportrait_url AS headportrait_url,
IFNULL(TRUNCATE(u.balance_gm,2),0.00) AS gouwuAccount,
IFNULL(TRUNCATE(u.balance_tx,2),0.00) AS tixianAccount,
IFNULL(TRUNCATE(u.balance,2),0.00) AS zongAccount,
IFNULL(TRUNCATE(chongzhi,2),0.00) AS chongzhi,
IFNULL(TRUNCATE(orderAmount,2),0.00) AS orderAmount,
IFNULL(TRUNCATE(leiJiMoney,2),0.00) AS leiJiMoney,
IFNULL(TRUNCATE(orderMoney,2),0.00) AS orderMoney,
IFNULL(TRUNCATE(saoMaMoney,2),0.00) AS saoMaMoney,
IFNULL(TRUNCATE(fanBeiZhuanMoney,2),0.00) AS fanBeiZhuanMoney,
sql查询多条数据
最新推荐文章于 2024-07-25 18:23:42 发布