SELECT DATE_FORMAT(dateline,'%Y-%m-d') AS `date`, COUNT(*) AS cnt FROM bbs_posts GROUP BY DATE_FORMAT(dateline,'%Y-%m-d') ORDER BY cnt DESC LIMIT 1;
select dateline from tt group by dateline order by count(*) desc limit 1
select date(bbs_posts),count(*) from bbs_posts group by date(bbs_posts) order by count(*) desc limit 1;或者用1楼的 DATE_FORMAT(date,format) 函数来代替 date()函数也可以。
DATE_FORMAT(dateline,'%Y-%m-d') AS `date`,
COUNT(*) AS cnt
FROM bbs_posts
GROUP BY DATE_FORMAT(dateline,'%Y-%m-d')
ORDER BY cnt DESC
LIMIT 1;
order by count(*) desc limit 1
from bbs_posts
group by date(bbs_posts)
order by count(*) desc
limit 1;或者用1楼的 DATE_FORMAT(date,format) 函数来代替 date()函数也可以。