mysql语句,哪个高效?或者还有其他更好的方法?
二个表travels,fans
第一种:$sql1 = "select count(*) as travels from travels where uid=1";
$sql2 = "select count(*) as ufans from fans where uid = 1";
$sql3 = "select count(*) as ffans from fans where fid = 1";以上三条sql获取travels,ufans,ffans第二种:
$sql = SELECT travels,ufans,ffans FROM (
SELECT COUNT(*) AS travels
FROM ty_travels T
WHERE T.uid = '1'
) t, (
SELECT SUM(IF(F.uid=1,1,0)) AS ufans,SUM(IF(F.fid=1,1,0)) AS ffans
FROM ty_fans F
) f";MySQL
二个表travels,fans
第一种:$sql1 = "select count(*) as travels from travels where uid=1";
$sql2 = "select count(*) as ufans from fans where uid = 1";
$sql3 = "select count(*) as ffans from fans where fid = 1";以上三条sql获取travels,ufans,ffans第二种:
$sql = SELECT travels,ufans,ffans FROM (
SELECT COUNT(*) AS travels
FROM ty_travels T
WHERE T.uid = '1'
) t, (
SELECT SUM(IF(F.uid=1,1,0)) AS ufans,SUM(IF(F.fid=1,1,0)) AS ffans
FROM ty_fans F
) f";MySQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货