mysql orderby 优化
SELECT *FROM news ORDER BY newstime DESC LIMIT 20,10;
SELECT * FROM news INNER JOIN ( SELECT id FROM news ORDER BY newstime DESC LIMIT 20,10) AS a USING(id);
linhonggang10 博主文章分类:mysql
mysql orderby 优化
SELECT *FROM news ORDER BY newstime DESC LIMIT 20,10;
SELECT * FROM news INNER JOIN ( SELECT id FROM news ORDER BY newstime DESC LIMIT 20,10) AS a USING(id);
下一篇:lamp
安装MySQLworkbench以及环境配置的详细教程
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M