How does MySQL query the list of dates?

Transferred from: http://blog.csdn.net/liufei198613/article/details/72643345

Select @num: [Email Protected]+1,date_format (adddate (' 2015-09-01 ', INTERVAL @num Day), '%y-%m-%d ') as Date
From Btc_user, (select @num: =0) t where Adddate (' 2015-09-01 ', INTERVAL @num Day) <= Date_format (Curdate (), '%y-%m-%d ')

Order by date;

The advantage of this method is that you do not need to create a stored procedure or a calendar table, the disadvantage is that you must have a table, the number of data bars is large enough to support the number of days you want to query

How does MySQL query the list of dates?