출처1 :&nbsp;<a href="https://stackoverflow.com/questions/23518345/generate-list-of-dates-and-count-online-posts-each-day">https://stackoverflow.com/questions/23518345/generate-list-of-dates-and-count-online-posts-each-day</a> 통계쿼리 같은 걸 짜다보면 날짜를 강제로 생성해서&nbsp;cross join으로 처리할 때가 있다.&nbsp; mysql, mariadb에서 날짜를 생성하는 쿼리이다. <div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>DROP&nbsp;VIEW&nbsp;if&nbsp;EXISTS&nbsp;vcm_date;</div><div>CREATE&nbsp;VIEW&nbsp;vcm_date&nbsp;AS&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;*</div><div>&nbsp;&nbsp;&nbsp;&nbsp;FROM&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;ADDDATE('1970-01-01',t4*10000&nbsp;+&nbsp;t3*1000&nbsp;+&nbsp;t2*100&nbsp;+&nbsp;t1*10&nbsp;+&nbsp;t0)&nbsp;vDate&nbsp;FROM</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;0&nbsp;t0&nbsp;UNION&nbsp;SELECT&nbsp;1&nbsp;UNION&nbsp;SELECT&nbsp;2&nbsp;UNION&nbsp;SELECT&nbsp;3&nbsp;UNION&nbsp;SELECT&nbsp;4&nbsp;UNION&nbsp;SELECT&nbsp;5&nbsp;UNION&nbsp;SELECT&nbsp;6&nbsp;UNION&nbsp;SELECT&nbsp;7&nbsp;UNION&nbsp;SELECT&nbsp;8&nbsp;UNION&nbsp;SELECT&nbsp;9)&nbsp;t0,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;0&nbsp;t1&nbsp;UNION&nbsp;SELECT&nbsp;1&nbsp;UNION&nbsp;SELECT&nbsp;2&nbsp;UNION&nbsp;SELECT&nbsp;3&nbsp;UNION&nbsp;SELECT&nbsp;4&nbsp;UNION&nbsp;SELECT&nbsp;5&nbsp;UNION&nbsp;SELECT&nbsp;6&nbsp;UNION&nbsp;SELECT&nbsp;7&nbsp;UNION&nbsp;SELECT&nbsp;8&nbsp;UNION&nbsp;SELECT&nbsp;9)&nbsp;t1,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;0&nbsp;t2&nbsp;UNION&nbsp;SELECT&nbsp;1&nbsp;UNION&nbsp;SELECT&nbsp;2&nbsp;UNION&nbsp;SELECT&nbsp;3&nbsp;UNION&nbsp;SELECT&nbsp;4&nbsp;UNION&nbsp;SELECT&nbsp;5&nbsp;UNION&nbsp;SELECT&nbsp;6&nbsp;UNION&nbsp;SELECT&nbsp;7&nbsp;UNION&nbsp;SELECT&nbsp;8&nbsp;UNION&nbsp;SELECT&nbsp;9)&nbsp;t2,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;0&nbsp;t3&nbsp;UNION&nbsp;SELECT&nbsp;1&nbsp;UNION&nbsp;SELECT&nbsp;2&nbsp;UNION&nbsp;SELECT&nbsp;3&nbsp;UNION&nbsp;SELECT&nbsp;4&nbsp;UNION&nbsp;SELECT&nbsp;5&nbsp;UNION&nbsp;SELECT&nbsp;6&nbsp;UNION&nbsp;SELECT&nbsp;7&nbsp;UNION&nbsp;SELECT&nbsp;8&nbsp;UNION&nbsp;SELECT&nbsp;9)&nbsp;t3,</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT&nbsp;0&nbsp;t4&nbsp;UNION&nbsp;SELECT&nbsp;1&nbsp;UNION&nbsp;SELECT&nbsp;2&nbsp;UNION&nbsp;SELECT&nbsp;3&nbsp;UNION&nbsp;SELECT&nbsp;4&nbsp;UNION&nbsp;SELECT&nbsp;5&nbsp;UNION&nbsp;SELECT&nbsp;6&nbsp;UNION&nbsp;SELECT&nbsp;7&nbsp;UNION&nbsp;SELECT&nbsp;8&nbsp;UNION&nbsp;SELECT&nbsp;9)&nbsp;t4)&nbsp;v</div><div>&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;vDate&nbsp;BETWEEN&nbsp;'2010-01-01'&nbsp;AND&nbsp;'2040-12-31';</div> </div>

[MySQL & MariaDB] 날짜 생성하기 make date