CREATE DEFINER=`localhost`@`%` PROCEDURE `测试`()
BEGIN
DECLARE i INTEGER DEFAULT 1;
DECLARE d VARCHAR (255);
WHILE i <= 100 DO
SET d = UUID();
INSERT INTO `database`.`table` (
`CBCASE_ID`,
`CB_NAME`
)
VALUES
(
d,
i+1
);
SET i = i + 1;
END
WHILE;
END