摘要: //性能尚可SELECT t1.id,t1.code FROM code AS t1 JOIN (SELECT ROUND(RAND()*((SELECT MAX(id) FROM code)-(SELECT MIN(id) FROM code))+(SELECT MIN(id) FROM code)) AS id) AS t2 WHERE t1.id >= t2.id AND t1.is_get=0 ORDER BY t1.id LIMIT 1 阅读全文
posted @ 2012-03-21 10:31 sh.feat. 阅读(168) 评论(0) 推荐(0)