mysql 获取每日新增总数量

SELECT DATE_FORMAT(createTime,'%Y-%m-%d') as time , count(*) as count FROM member GROUP BY  time;

 

posted @ 2015-10-21 17:31  傻傻丶乐  阅读(2903)  评论(0)  编辑  收藏  举报