mysql存储过程

drop procedure sp_merge; //创建1个存储过程
DELIMITER // 设定分隔符

CREATE PROCEDURE sp_merge()
BEGIN
DECLARE tbl_name VARCHAR(100); //DECLARE
START TRANSACTION;
SET @i:=0; //设置1个变量
SET tbl_name = "t_game_club";

while @i<10 do
PREPARE cFROM 'select * from table limit ?,1';//预定义一个语句，并将它赋给s1
EXECUTE s1 USING @i;
DEALLOCATE PREPARE s1; //释放一个预定义语句的资源
SET @i = @i+1;
END WHILE;
COMMIT;

END//
DELIMITER ;

执行
call sp_merge;