1.建立一个view a,
view就是SELECT * FROM tab WHERE mo_date BETWEEN '2006-08-25 00:00:01' AND '2006-08-25 23:59:59'2。SELECT (SELECT count(*) FROM a) as total,(SELECT count(*) FROM a WHERE is_right=1) as succ,(SELECT count(*) FROM a WHERE is_right=0) as failed,(SELECT count(*) FROM a WHERE mo_type='Q') as other
view就是SELECT * FROM tab WHERE mo_date BETWEEN '2006-08-25 00:00:01' AND '2006-08-25 23:59:59'2。SELECT (SELECT count(*) FROM a) as total,(SELECT count(*) FROM a WHERE is_right=1) as succ,(SELECT count(*) FROM a WHERE is_right=0) as failed,(SELECT count(*) FROM a WHERE mo_type='Q') as other
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货