mysql
ccheers_
这个作者很懒,什么都没留下…
展开
-
mysql GROUP BY 取分组中最小(OR 最大)的一条记录
代码 select d.* FROM sem_database_export as d LEFT JOIN ( SELECT a.id,a.keyname,a.shebei,a.adverts_lei,a.adverts_pinpai, MAX(a.page) as page,MAX(a.state) as state from sem_database_export as a GROUP BY...原创 2019-04-10 10:46:06 · 2202 阅读 · 0 评论 -
Mysql 随机日期
Mysql 随机日期转载自 https://zhidao.baidu.com/question/558371333.html 转载自 https://zhidao.baidu.com/question/558371333.html DATE_ADD( DATE_ADD(‘2019-01-01 00:00:00’, INTERVAL FLOOR(1 + (RAND() * 86400)) S...转载 2019-07-18 12:59:34 · 667 阅读 · 0 评论