摘要： #每周注册人数对每周注册会员数量一目了然！dateline: 注册时间戳DATE_FORMAT(FROM_UNIXTIME(dateline),'%Y'): 获取当前年份weekofyear(FROM_UNIXTIME(dateline)) ： 获取当前周数weeknum: 周数按年份、月份分组并排序：select DATE_FORMAT(FROM_UNIXTIME(dateline),'%Y') yearnum,weekofyear(FROM_UNIXTIME(dateline)) weeknum,COUNT(*) as '注册人数' from 阅读全文