More than 1 year has passed since last update.

MariaDBで任意の期間のカレンダーを生成する

mariadb
,MySQL

Last updated at 2024-02-27Posted at 2024-02-27

WITH RECURSIVEを使う。

WITH RECURSIVE dates(date) AS (
	SELECT
		'2024-01-01'
	UNION ALL
	SELECT ADDDATE(date,1)
FROM dates WHERE DATE < '2024-01-18' )
SELECT * FROM dates;

結果

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up