CREATE TABLE nums(id INT AUTO_INCREMENT,PRIMARY KEY);
# select * from nums;
-- insert into nums set id=default;
--
-- INSERT INTO nums (id) values(DEFAULT);
--
-- show create table nums;
GO
DELIMITER //
CREATE PROCEDURE INSERT_NUMS(NUM INT)
BEGIN
SET @x = 0;
REPEAT
INSERT INTO nums SET id=DEFAULT;
SET @x = @x + 1;
UNTIL @x > NUM
END REPEAT;
END
//
CALL INSERT_NUMS(100);
SELECT DATE_FORMAT(DATE_ADD(CURRENT_DATE(),INTERVAL -id DAY),'%Y-%m-%d')
FROM nums n
WHERE id<=7
拿到上面的语句 再 LEFT 订单统计 关联IFNULL(数量,0)就可以了。