SELECT
(@num:=@num + 1) AS num,SUBDATE(SUBDATE(CURDATE(),INTERVAL 1 DAY), INTERVAL @num-1 DAY) date
FROM
z_user,(SELECT @num:=0) AS t
转载于:https://www.cnblogs.com/zwliu/p/7560940.html
SELECT
(@num:=@num + 1) AS num,SUBDATE(SUBDATE(CURDATE(),INTERVAL 1 DAY), INTERVAL @num-1 DAY) date
FROM
z_user,(SELECT @num:=0) AS t
转载于:https://www.cnblogs.com/zwliu/p/7560940.html