Mysql 统计上一个月接入的设备总数 SELECT COUNT(*) as count FROM device WHERE MONTH(create_time) = MONTH(CURRENT_DATE - INTERVAL 1 MONTH) AND YEAR(create_time) = YEAR(CURRENT_DATE - INTERVAL 1 MONTH);