CREATE PROCEDURE P1()
BEGIN
DECLARE i INT;
VALUES
(
CONCAT('CPZW00000000', 60000000 + i),
'column2',
'column3',
BEGIN
DECLARE i INT;
SET i=1;
i < 100000
DO
INSERT INTO cp_coupons_detailVALUES
(
CONCAT('CPZW00000000', 60000000 + i),
'column2',
'column3',
'column4',
);
set i=i+1;
END WHILE;
END