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;