![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
xh_wanghe
这个作者很懒,什么都没留下…
展开
-
MySql count 去掉重复
1.select count(distinct CName) from Course2.select count(CName) from (select distinct CName from Course) as tempas可有可无。temp作为别名,若无则提示错误:1248 – Every derived table must have its own alias...原创 2012-03-28 14:03:11 · 1919 阅读 · 0 评论 -
深入研究mysql中group by与order by取分类最新时间内容
本文就和大家一起深入研究下mysql中group by与order by.下面是我模拟我的内容表 我现在需要取出每个分类中最新的内容select * from test group by category_id order by `date`结果如下 明显。这不是我想要的数据,原因是msyql已经的执行顺序是 引用写的顺序:select ... from... where......原创 2012-03-28 14:04:14 · 146 阅读 · 0 评论 -
MySql 查询特定时间段数据
select * from wap_content where week(created_at) = week(now)如果你要严格要求是某一年的,那可以这样查询一天:select * from table where to_days(column_time) = to_days(now());select * from table where date(colu...原创 2012-11-21 14:48:48 · 230 阅读 · 0 评论 -
随机从数据表中取N条数据(mysql)
SELECT * FROM faq WHERE id >= ((SELECT MAX(id) FROM faq)-(SELECT MIN(id) FROM faq)) * RAND() + (SELECT MIN(id) FROM faq) LIMIT 92012-10-10 09:48:01 · 146 阅读 · 0 评论