The method of establishing Mysql time Dimension Table
This article mainly gives you a brief introduction to the method of establishing Mysql time dimension table. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article can bring you some practical help. I hope that the method of establishing Mysql time dimension table can bring you some practical help.
1. Create a table test_date for date self-growth, with only one column of ID in it, write a storage, and insert sequential numbers.
BEGIN#Routine body goes here...declare id int;set id=1;while id
