How does mysql obtain the result set of each day in a time period? if it is not set to 0, I may have BETWEEN & nbsp; in the range of 30 days, but it may only have a value for one day. I hope the dates of the other 29 days will be displayed, but count0, so I want to know how to get the time period every day. thank you. & Nbsp; ------ solution ------------------ only the & nbsp; SQL & nbsp; command cannot be used ------ how to obtain the result set of each day in the time range of mysql, if not, 0
I may have BETWEEN in the range of 30 days, but it may only be worth one day.
You want to display the dates for the other 29 days, but count = 0
So I want to know how to get the time period every day. thank you.
------ Solution --------------------
Only SQL commands cannot be used.
------ Solution --------------------
Then we can query it and construct it with php code.