We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Draw The Triangle 1
  5. Discussions

Draw The Triangle 1

  • [deleted]     + 0 comments

    For MySQL

    DELIMITER $$

CREATE PROCEDURE printPattern()
BEGIN
    DECLARE i INT DEFAULT 20;
    
    WHILE i>0 DO
        SELECT IF(i=1, "*", REPEAT("* ", i));
        SET i = i-1;
    END WHILE;
END$$

DELIMITER ;

CALL printPattern();