#1248 - Every derived table must have its own alias
就是一直是这个常见的错误……但是不知道该怎么解决orz语句是以下的两句
$sql3="select u.*
from user u
having u.user_id= any(select b.user_id
from (select b.*
from blogs b
group by user_id
order by count(*)
)
where rownum<=6");$sql="select b.* from blogs b
having b.id = any (
select c.blog_id from (select c.blog_id,count(*)
from comment c
group by c.blog_id order by count(*) DESC
) where rownum<=5 )";
就是一直是这个常见的错误……但是不知道该怎么解决orz语句是以下的两句
$sql3="select u.*
from user u
having u.user_id= any(select b.user_id
from (select b.*
from blogs b
group by user_id
order by count(*)
)
where rownum<=6");$sql="select b.* from blogs b
having b.id = any (
select c.blog_id from (select c.blog_id,count(*)
from comment c
group by c.blog_id order by count(*) DESC
) where rownum<=5 )";
解决方案 »
- 新手关于mb_strlen的问题。
- mysql数据从4.1.20导入到3.23.54 乱码问题怎么解决啊?
- 请问该怎么解读这段代码?
- 以脚本形式运行php中可以使用PDO吗?
- 求一对加密解密算法 一个ubuntu shell 脚本的 一个PHP的 或者给个算法描述 谢谢!
- 时间计算问题?
- 跨服务器 打开文件问题
- 一个有关密码较验的问题?
- 救急,请哪位高手吧下边的弹出提示框的代码改成弹出遮罩层,或者弹出一张图片遮罩
- 求高手解答,Wampserver 搭建Joomla 网站在云服务器上发布上线 外网无法访问的问题
- php接收手机http post的问题
- php c++扩展,如何接收一个对象,修改其属性后直接返回该对象
from user u
having u.user_id= any(select b.user_id
from (select b.*
from blogs b
group by user_id
order by count(*)
) tmp
where rownum<=6");$sql="select b.* from blogs b
having b.id = any (
select c.blog_id from (select c.blog_id,count(*)
from comment c
group by c.blog_id order by count(*) DESC
) tmp where rownum<=5 )";
每次派生出来的表必须要有它自己的别名
ls的好强!又见到你了!上一个问题也是你解答的!
然后运行了之后,还是有问题,第一个的报错是
#1054 - Unknown column 'b.user_id' in 'field list'然后如果把b.blog的前缀去掉,报错就变成#1054 - Unknown column 'rownum' in 'where clause'顺便问一下,运行php,错误显示Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in index.php on line 149
就是因为sql有问题是么?
晚些
from user u
having u.user_id= any(select tmp.user_id
from (select b.*
from blogs b
group by user_id
order by count(*)
) tmp
where rownum<=6");没测试。
#1054 - Unknown column 'rownum' in 'where clause'
如何解决T_T
如何做到这一点?
sorry...no chinese input here...i only ctrl+c/v maybe can not explain question clearT_T
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/yiling/public_html/test/index.php on line 172
php是$sql1="select * from (select * from blogs where private=1 order by Btime DESC) where rownum<=5";
$query1=mysql_query($sql1);
while($blog1=mysql_fetch_array($query1)){
echo $blog1['title'];
echo $blog1['Btime'];
}不知道该怎么解决orz
子查询的效率不高。可以用表连接。