统计每一天的用户注册数sql语句
SELECT count(*),
DATE_FORMAT(FROM_UNIXTIME(ctime),'%m-%d') as time FROM zj_admin
WHERE ctime BETWEEN unix_timestamp('2014-3-1')
AND (unix_timestamp('2014-4-30')+3600*24*30) GROUP BY DATE_FORMAT(FROM_UNIXTIME(ctime),'%m-%d')
DATE_FORMAT(FROM_UNIXTIME(ctime),'%m-%d') as time FROM zj_admin
WHERE ctime BETWEEN unix_timestamp('2014-3-1')
AND (unix_timestamp('2014-4-30')+3600*24*30) GROUP BY DATE_FORMAT(FROM_UNIXTIME(ctime),'%m-%d')