1.表里面的字段是时间格式, 查询用户每月数据
SELECT DATE_FORMAT(starttime, '%Y-%m') AS starts, COUNT(*) FROM ceshi GROUP BY starts;
2.表里面的字段是时间戳, 查询用户每月数据
SELECT FROM_UNIXTIME(createtime,'%Y-%m') AS starts, COUNT(*) FROM ceshi GROUP BY starts;
SELECT DATE_FORMAT(starttime, '%Y-%m') AS starts, COUNT(*) FROM ceshi GROUP BY starts;
SELECT FROM_UNIXTIME(createtime,'%Y-%m') AS starts, COUNT(*) FROM ceshi GROUP BY starts;