表book
id,name
1 三国演义
表bookcontent
id,bookid,title
1 1 第一节
2 1 第二节
3 1 第三节
把书按自增ID排序并调列出书的最新章节
select * FROM book as a left join bookcontent as b
on b.id =(select max(id) from bookcontent where bookid=a.id)
order by a.id desc limit 10现在这个有点慢,怎么优化下
id,name
1 三国演义
表bookcontent
id,bookid,title
1 1 第一节
2 1 第二节
3 1 第三节
把书按自增ID排序并调列出书的最新章节
select * FROM book as a left join bookcontent as b
on b.id =(select max(id) from bookcontent where bookid=a.id)
order by a.id desc limit 10现在这个有点慢,怎么优化下
解决方案 »
- mysql数据库脚本事务如何控制?
- mysql中关于limit查询(急)
- 关于MySQL跨服务器查询的问题
- 请叫各位大哥!小弟在MySql中怎么初始化一个表中16位的自动流水号
- 数据库里的数据突然全部不见了,怎么恢复呀??(要多少都给)
- 一个简单的问题,我想把一段很长的内容存入库中,比如说一封长信的内容,我该把字段设为什么类型合适呢,
- 此帖问题已解决,那位近来接分
- 关于mysql字符集的问题,怎么设置都不对啊
- Mysql5.5.15 安装过程start service 错误,如何重装?学弟在线跪求回复。。。
- Mysql 的fetch时间过长怎么办?
- 请教几个MYSQL存储过程的问题
- mysql 一张表最大的存储空间是多大啊?
on a.id=b.id
inner join
(select bookid,max(id) as ma from bookcontent ) c
on b.id =c.ma
order by a.id desc limit 10
(select * from bookcontent as b
where not exists(select 1 from bookcontent where bookid=b.bookid and id>b.id)
) c
on a.id=c.bookid;
inner join bookcontent b
on a.id=c.bookid
inner join
(select bookid,max(id) as ma from bookcontent group by bookid) c
on b.id =c.ma and b.bookid=c.bookid
order by a.id desc limit 10
from (select bookid,max(id) as ma from bookcontent group by bookid) c
inner join bookcontent b on c.ma=b.id
right join book a on a.id=b.bookid
show index from book