DROP PROCEDURE IF EXISTS `ceshi11`;CREATE DEFINER = `root`@`%` PROCEDURE `ceshi11`(IN `i` int)
BEGIN
DECLARE j INT DEFAULT 1; create TEMPORARY TABLE table1
(
num1 int NULL
) WHILE j <i DO
INSERT INTO table1(num1 ) VALUES (1) ;
SET j = j + 1;
END WHILE;
select * FROM table1;
END;
BEGIN
DECLARE j INT DEFAULT 1; create TEMPORARY TABLE table1
(
num1 int NULL
) WHILE j <i DO
INSERT INTO table1(num1 ) VALUES (1) ;
SET j = j + 1;
END WHILE;
select * FROM table1;
END;
CREATE DEFINER = `root`@`%` PROCEDURE `ceshi11`(IN `i` int)
BEGIN
DECLARE j INT DEFAULT 1;
create TEMPORARY TABLE table1
(
num1 int NULL
);
WHILE j <i DO
INSERT INTO table1(num1) VALUES (1) ;
SET j = j + 1;
END WHILE;
select * FROM table1;
END;
$$call ceshi11(10)