mysql 插入1000条数据_MySQL批量插入1000条数据

create PROCEDURE 批量插入1000条数据()

BEGIN

DECLARE i int;

set i = 1;

WHILE i < 120 DO

insert into `1000`(user,password) values(concat("UU",i),concat("PWD",i));

set i = i+1;

END WHILE;

END

//**************************************************************

方法_2

DELIMITER ;;

#创建过程

CREATE PROCEDURE test_insert1 ()

BEGIN

DECLARE i INT DEFAULT 3;

WHILE i<100

DO

insert into category_ (id,name) values (i,i);

SET i=i+1;

END WHILE ;

commit;

END;;

CALL test_insert1();