MySQLWhile语句

drop procedure IF EXISTS u_head_and_low_pro;

delimiter //
create procedure u_head_and_low_pro()
begin
  DECLARE n int DEFAULT 10;
    SET n = n -1;
    WHILE n > 0 DO
            SELECT n;
            set n = n - 1;
  END WHILE;
end
//

CALL u_head_and_low_pro();