<pre name="code" class="html">//在一条语句中count出不同的条件,记录一下 ..
SELECT
SUM( goods_amount ) AS money,
count( * ) AS num,
count(if(pay_status=1,true,null)) AS success,
count(if(pay_status=2,true,null)) AS fall
FROM `tab_order_info`
WHERE user_id = 11 </pre>
<pre></pre>
<br>
SELECT
SUM( goods_amount ) AS money,
count( * ) AS num,
count(if(pay_status=1,true,null)) AS success,
count(if(pay_status=2,true,null)) AS fall
FROM `tab_order_info`
WHERE user_id = 11 </pre>
<pre></pre>
<br>