当前位置:Gxlcms > PHP教程 > 使用临时表查询数据的一个例子

使用临时表查询数据的一个例子

时间:2021-07-01 10:21:17 帮助过:16人阅读

  1. $sql3="CREATE TEMPORARY TABLE atmp_table(uid int(11),dnum int(20) not null)";

  2. mysql_query($sql3);
  3. $sql3="INSERT into atmp_table(uid,dnum) SELECT uid,count(soid) as dnum
  4. FROM `cy_score2`
  5. where (nei='下载' or nei='下载试题')
  6. group by uid having dnum>150
  7. order by dnum desc limit 10";
  8. mysql_query($sql3);
  9. $sql3="select a.uid,count(b.tid) as unum from atmp_table a left join cy_test b on a.uid=b.uid
  10. group by b.uid
  11. order by a.dnum desc,unum asc limit 5";
  12. $query4=mysql_query($sql3);
  13. $rs=mysql_fetch_array($query4) ;

人气教程排行