34,594
社区成员
发帖
与我相关
我的任务
分享MySql里面应该怎样优化这条sql语句?
select p.id,p.nickname,p.grade,p.union_name,c.x,c.y from player_info p ,city c where p.u_id=c.u_id group by p.p_id order by p.p_grade desc limit 0,10
...全文
请发表友善的回复…
发表回复
SQL77 2009-08-17
- 打赏
- 举报
select
p.id,p.nickname,p.grade,p.union_name,c.x,c.y
from player_info p ,
city c w
here p.u_id=c.u_id
group by p.p_id
order by p.p_grade desc limit 0,10
语句好像没什么好优化的,加索引
p.id,p.nickname,p.grade,p.union_name,c.x,c.y
from player_info p ,
city c w
here p.u_id=c.u_id
group by p.p_id
order by p.p_grade desc limit 0,10
语句好像没什么好优化的,加索引
flyfly2008 2009-08-17
- 打赏
- 举报
select p.id,p.nickname,p.grade,p.union_name,c.x,c.y from player_info p join inner city c on p.u_id=c.u_id group by p.p_id order by p.p_grade desc limit 0,10
wujumao 2009-08-17
- 打赏
- 举报
select p.id,p.nickname,p.grade,p.union_name,c.x,c.y from player_info p ,
city c where p.u_id=c.u_id group by p.p_id order by p.p_grade desc limit 0,10
