Username: menelkot Temat: while 
DELIMITER $$

CREATE PROCEDURE a()
BEGIN
    DECLARE counter INT DEFAULT 10;
    WHILE counter > 0 DO
     	SET counter = counter + 1;
    END WHILE;

END$$

DELIMITER ;
CALL a();