DROP PROCEDURE test_insert ;
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN
DECLARE i INT DEFAULT 1000000;
WHILE i<1100000
DO
INSERT INTO loan_app VALUES
(
i,
i,
i,
'3999',
8,
5000+i,
0.55,
1,
i,
30,
'MONTHLY',
1,
CONCAT('TITLE',i),
CONCAT('DESC',i),
CONCAT('SOURCE',i),
'2016-11-15 11:30:00',
'2016-11-15 11:30:00',
'2016-11-15 11:30:00',
null,
i,
'',
'',
'2016-11-15 11:31:00',
CONCAT('上海',i),
CONCAT('sc',i),
null,
null,
''
);
SET i=i+1;
END WHILE ;
END;;
CALL test_insert();