SELECT @date := DATE_ADD(@date, INTERVAL 1 DAY) AS dates
FROM mysql.help_relation,
(SELECT @date := DATE_SUB('2019-08-01', INTERVAL 1 DAY)) d
WHERE @date BETWEEN @date AND DATE_SUB('2019-08-20', INTERVAL 1 DAY)
SELECT @date := DATE_ADD(@date, INTERVAL 1 DAY) AS dates
FROM mysql.help_relation,
(SELECT @date := DATE_SUB('2019-08-01', INTERVAL 1 DAY)) d
WHERE @date BETWEEN @date AND DATE_SUB('2019-08-20', INTERVAL 1 DAY)