MYSQL php RAND随机查询太慢了,请教改一下这个代码!

1)随机取出5条记录用sql语句就行了;mysql如下:"select * from youtable order by rand() limit 5";2)同样随机取5-10条:num=rand(5,10);sql="select * from youtable order by rand() limit $num";
MYSQL php RAND随机查询太慢了,请教改一下这个代码!
1)随机取出5条记录用sql语句就行了;
mysql如下:"select * from youtable order by rand() limit 5";

2)同样随机取5-10条:
$num=rand(5,10);
$sql="select * from youtable order by rand() limit $num";2019-09-08
mengvlog 阅读 10 次 更新于 2025-07-20 21:18:04 我来答关注问题0
檬味博客在线解答立即免费咨询

mySQL相关话题

Copyright © 2023 WWW.MENGVLOG.COM - 檬味博客
返回顶部