文章表
从随机栏目下随机取几条记录
求高效写法
从随机栏目下随机取几条记录
求高效写法
解决方案 »
- 为什么这样 (版本5.0.22语法错误,4.1.12顺利通过)
- ubuntu 10 安装mysql ,ERROR 2002 (HY000): Can't connect to local MySQL server throu
- mysql导出数据出现的问题
- 4.0编码问题
- 急!red hat9.0 如何卸载mysql 或者 查找密码?
- 为什么每次数据查询后只能显示一次结果?
- 请问mysql中的text字段有大小的限制吗?最大可存放多少字节?
- mysql最近老是Aborted_connects值很高,有什么日记可以查看到是哪写连接被拒绝了吗?
- Mysql,关于not null的,看到一个以前的帖子,有点问题
- 主键无效的问题,请教
- where加“字段” + “<>”+值是什么含义
- access denied for user ''@'localhost'(using password:NO)
随机取十条写法
select * from tb order by newid() limit 10;
伪随即十条
select * from tb where id between 100 and 110;
select * from tb where id between 150 and 160;
FROM `table` AS t1 JOIN (SELECT ROUND(RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`))+(SELECT MIN(id) FROM `table`)) AS id) AS t2
WHERE t1.id >= t2.id
ORDER BY t1.id LIMIT 10;
select * from tb order by newid() limit 10 where catelogId=1