Mysql随机数据查询命令如下：
SELECT
*
FROM
niceimg
WHERE
id >= (
(SELECT MAX(id) FROM niceimg) – (SELECT MIN(id) FROM niceimg)
) * RAND() + (SELECT MIN(id) FROM niceimg)
LIMIT 1
发表评论 取消回复