MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãŸã¡ - ã™ãŽã‚ƒãƒ¼ã‚“メモhttp://mysql-casual.org/2011/11/mysql-casual-advent-calendar-2011.html ã®6日目ã®è¨˜äº‹ã¨ã—ã¦æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€sugyanã§ã™ã€‚ å‹¢ã„ã§å‚åŠ è¡¨æ˜Žã—ã¦ã—ã¾ã„ã€ä»Šæ—¥æ…Œã¦ã¦ä¹…ã—ã¶ã‚Šã«MySQLを触りã¾ã—ãŸã€‚ MySQLã§FizzBuzz ストアドプãƒã‚·ãƒ¼ã‚¸ãƒ£ã£ã¦ä½¿ã£ãŸã“ã¨ç„¡ã‹ã£ãŸã®ã§åˆã‚ã¦è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚ DROP PROCEDURE IF EXISTS FizzBuzz; delimiter // CREATE PROCEDURE FizzBuzz(n INT) BEGIN DECLARE i INT DEFAULT 1; WHILE i <= n DO SELECT CASE WHEN i % 3 = 0 AND i % 5 = 0 THEN 'FizzBuzz' WHEN i % 5 = 0 THEN 'Buzz'
{{#tags}}- {{label}}
{{/tags}}