数据库-批量构造数据

CREATE DEFINER PROCEDURE test_insert( )
BEGIN
DECLARE i INT;
SET i = 1;
WHILE i <= 100 DO

	INSERT INTO `data_used_appy_d`(USED_APPY_ID) 
	VALUES (i);

set i=i+1;
END WHILE;
END