关于#MySQL#的问题，如何解决？

Question

MySQL
分别用While语句、repeat语句和Loop语句求1+2+…100

Answer 1

SET @i = 1;
SET @sum = 0;
WHILE @i <= 100 DO
    SET @sum = @sum + @i;
    SET @i = @i + 1;
END WHILE;
SELECT @sum;

SET @i = 1;
SET @sum = 0;
REPEAT
    SET @sum = @sum + @i;
    SET @i = @i + 1;
UNTIL @i > 100 END REPEAT;
SELECT @sum;

SET @i = 1;
SET @sum = 0;
loop_label: LOOP
    SET @sum = @sum + @i;
    SET @i = @i + 1;
    IF @i > 100 THEN
        LEAVE loop_label;
    END IF;
END LOOP;
SELECT @sum;