mysql数据库中循环插入

DROP PROCEDURE test_insert ;DELIMITER ;;#声明;;为结束标志CREATE PROCEDURE test_insert ()BEGINDECLARE i INT;set i=0;WHILE i<10DOINSERT INTO user(user_id,user_name)VALUES(CONCAT('041431',i),CONCAT('name',i));SET i=i+1;END WHILE ;END;;CALL test_insert();;