mysql 语句 循环入数据库（Navicat）

1.sql创建函数并调用

DELIMITER ;;
CREATE PROCEDURE test_insert2 () 
BEGIN 

DECLARE i INT DEFAULT 1;

WHILE i<100 
DO 
insert into goods(good_name,good_price,de) values ('gui',i,'hao'); 
SET i=i+1; 
END WHILE ; 
commit; 

END;; 

CALL test_insert2();

2.手动创建函数

BEGIN 

DECLARE i INT DEFAULT 11101;

WHILE i<=1000000
DO 
insert into usertest (UserId,Id,k,Username) VALUES (1000000000+i,2,3,'dada');
SET i=i+1; 
END WHILE ; 
commit; 

END

3.手动创建表

create table ANOTHERUSER (

                  UserId  int(10) unsigned not null auto_increment,

                  Id     bigint(20) unsigned not null default 0,

                  k       int(10) unsigned not null default 0,

                  UserName varchar(120) not null default '',

                  PRIMARY KEY  (UserId),

                  KEY index_Id (Id),

                  KEY index_k (k)

         )Engine=InnoDB  DEFAULT CHARSET=UTF8;