![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
jonlys
这个作者很懒,什么都没留下…
展开
-
mysql 时间日期比较大小
select * from student where '2012-02-27 00:00:00' created_dateselect * from student where UNIX_TIMESTAMP('2012-02-27 00:00:00') UNIX_TIMESTAMP(created_date);SELECT * FROM student WHERE (原创 2012-03-02 13:29:59 · 10583 阅读 · 1 评论 -
mysql 随机取数据 高效
mysql随机取数据 不连续SELECT * FROM `table`WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`)))ORDER BY id LIMIT 1;原创 2013-02-18 15:23:26 · 436 阅读 · 0 评论