原来以为mysql没有随机输出数据的方法呢,google后还是搜索到了结果,代码如下:
select * from tablename order by rand() limit 10
Archives
- May 2011
- April 2011
- February 2011
- December 2010
- November 2010
- October 2010
- August 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
Links
Recent Comments
