09 17 2009

1

Mysql 随机取 200条记录

分类: MySql 标签: mysql 阅读: 318

select * from [表名] order by rand() limit 200;

select top 200 * from [表名] order by NEWID();//mssql做法!

上一篇:mootools
回复
登陆
分类