An example of using temporary tables to query data
Release： 2016-07-25 09:05:44
Original
1098 people have browsed it
-
-
$sql3="CREATE TEMPORARY TABLE atmp_table(uid int(11),dnum int(20) not null)"; - mysql_query($sql3);
- $sql3="INSERT into atmp_table(uid,dnum) SELECT uid,count(soid) as dnum
- FROM `cy_score2`
- where (nei='下载' or nei='下载试题')
- group by uid having dnum>150
- order by dnum desc limit 10";
- mysql_query($sql3);
- $sql3="select a.uid,count(b.tid) as unum from atmp_table a left join cy_test b on a.uid=b.uid
- group by b.uid
- order by a.dnum desc,unum asc limit 5";
- $query4=mysql_query($sql3);
- $rs=mysql_fetch_array($query4) ;
-
|
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
