EugeneX MiniWeb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Все дни недели списком из MySQL ======
Проскользнула интересная задача на `стеке` из MySQL вывести все дни недели списком, реализовал в NoTable режиме.

Получился весьма забавный код =)))

<code mysql>
SELECT days_with_seq.SeqValue, days_with_seq.`Day`, DAYOFWEEK(days_with_seq.`Day`) as DOW_NUM,
	CASE DAYOFWEEK(days_with_seq.`Day`)
   	WHEN 1 THEN "Завтра на работу"
   	WHEN 2 THEN "Понедельник день тяжолый"
   	WHEN 3 THEN "Вторник"
   	WHEN 4 THEN "Середина недели"
   	WHEN 5 THEN "Маленькая пятница"
   	WHEN 6 THEN "Тяпница"
   	WHEN 7 THEN "Выходной"
		ELSE "Ошибка?"
	END AS DOW
FROM (
	SELECT SeqValue, DATE_ADD(NOW(), INTERVAL sequence.SeqValue DAY) AS "Day"
	FROM (SELECT
   		(TWO_1.SeqValue + TWO_2.SeqValue + TWO_4.SeqValue + TWO_8.SeqValue + TWO_16.SeqValue) SeqValue
		FROM
	   	(SELECT 0 SeqValue UNION ALL SELECT 1 SeqValue) TWO_1
			CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 2 SeqValue) TWO_2
			CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 4 SeqValue) TWO_4
			CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 8 SeqValue) TWO_8
			CROSS JOIN (SELECT 0 SeqValue UNION ALL SELECT 16 SeqValue) TWO_16
	) as sequence
) days_with_seq;
</code>

EugeneX MiniWeb

User Tools

Site Tools

Page Tools