mysql中如何随机提取数据库记录
展开全部
WebjxCom提示：帮朋友改个asp的相关产品显示要用到随机读取当前类别的前10个产品，Google了下收藏的 mysql中随机提取数据库记录 -------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select * from tablename order by rand() limit 10 select * from tablename order by rand() limit 10sqlserver中随机提取数据库记录 -------------------------------------------------------------------------------- view plaincopy to clipboardprint? select top 10 * from tablename order by NEWID() select top 10 * from tablename order by NEWID()Access中随机提取数据库记录 -------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select * from tablename order by rand() limit 10 select * from tablename order by rand() limit 10sqlserver中随机提取数据库记录 -------------------------------------------------------------------------------- view plaincopy to clipboardprint? select top 10 * from tablename order by NEWID() select top 10 * from tablename order by NEWID()Access中随机提取数据库记录 -------------------------------------------------------------------------------- view plaincopy to clipboardprint?
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
