rdlabo/gist:6a939c9b20e12008fa481e28d930bbb2

Created July 7, 2017 06:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rdlabo/6a939c9b20e12008fa481e28d930bbb2.js"></script>
Save rdlabo/6a939c9b20e12008fa481e28d930bbb2 to your computer and use it in GitHub Desktop.

Download ZIP

過去365日の日付をカルムで表示（サブクエリ等にお使い下さい）

Raw

gistfile1.txt

	SELECT
	DATE_FORMAT(DATE_ADD(NOW(), INTERVAL @i := @i - 1 DAY),'%Y-%m-%d') create_date
	FROM `information_schema`.COLUMNS,(SELECT @i:=0) s
	LIMIT 365

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment