mysql-SP-While-Leave-global&local-var.sql

select version() as 'mysql version';
#delimiter \\:
drop procedure if exists p1;
create procedure p1()
begin
declare ctr int default 0;
declare i int default 10;
myloop: WHILE (ctr < i) DO 
   #SET cnt = (SELECT COUNT(*) FROM temp_results WHERE result = "true");
    #select @ctr := ctr + 1;#only works for @variables( variales globales)
    #set ctr=@ctr;#passing value  from global to local
    set ctr = ctr + 1;#using only local variables
    SELECT ctr;
   IF ctr > 5 THEN
      SELECT concat("last value of ctr: ",ctr) as LVCTR;
      LEAVE myloop;
   END IF;
END WHILE myloop;
end \\
call p1();