-- ------------------------loop---------------------------
delimiter $
DROP PROCEDURE IF EXISTS my_count $
CREATE PROCEDURE my_count()
BEGIN
DECLARE count INT DEFAULT 0;
my_loop:
LOOP
SET count=count+1;
IF(count=10) THEN
LEAVE my_loop;
END IF;
SELECT CONCAT(count," is select value ");
END LOOP ;
SELECT "i can count TO 10";
END $
delimiter;
CALL my_count();
DROP PROCEDURE my_count;