存储过程练习

存储过程一：

DROP PROCEDURE if EXISTS test;
delimiter ;;
CREATE PROCEDURE test()
BEGIN
DECLARE i INT;
DECLARE s2 VARCHAR(100);
set i =300;
set s2='lala';
while(i<=400)DO
INSERT INTO team VALUES(i,concat(s2,i));
set i=i+1;
END WHILE;
END;;
delimiter ;

CALL test();

 

存储过程二：

DROP PROCEDURE IF EXISTS intest;

delimiter ;;
CREATE PROCEDURE intest(in startId INT,in endId INT, IN team_name VARCHAR(20), OUT reslut VARCHAR(30))
BEGIN
while(startId<=endId)DO
INSERT INTO team VALUES(startId,concat(team_name,startId));
set startId=startId+1;
end while;
set reslut = CONCAT(team_name,endId);
END;;
delimiter ;

CALL intest(20,30,'测试',@reslut);
select @reslut;