[sql] view plain copy <span style="font-size:18px;">DROP PROCEDURE if exists test_insert ; DELIMITER ;; CREATE PROCEDURE test_insert () BEGIN DECLARE i INT DEFAULT 1;# can not be 0 WHILE i<1000 DO insert into SS_BOOK values (i, CONCAT("00000",i) , CONCAT('book',i), 1, CONCAT('book_description',i)); SET i=i+1; END WHILE ; commit; END;; CALL test_insert();</span>