创建表格
CREATE TABLE gy_person_t
(
id
int(10) NOT NULL AUTO_INCREMENT,
person_Name
varchar(50) DEFAULT NULL,
person_Code
varchar(50) DEFAULT NULL,
age
int(10) DEFAULT NULL,
phone
varchar(255) DEFAULT NULL,
address
varchar(255) DEFAULT NULL,
sex
varchar(50) DEFAULT NULL,
type
varchar(255) DEFAULT NULL,
createby
int(255) DEFAULT NULL,
deleteflag
tinyint(4) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
存储过程
delimiter $$
CREATE PROCEDURE myproc () BEGIN
DECLARE
num INT;
SET num = 700535;
WHILE
num < 800000 DO
INSERT INTO gy_person_t ( id, person_Name, person_Code, age, phone, address, sex, type, createby, deleteflag )
VALUES
(
10000 + num,
concat( "shengseng", num ),
concat( "bianma", num ),
18,
15800000000,
'中国',
'man',
'customer',
1258,
0
);
SET num = num + 1;
END WHILE;
END $$
DROP PROCEDURE myproc;
CALL myproc ();
第二种方式
表中插入数据
CREATE PROCEDURE insertData(in count int)
BEGIN
declare i int default 20;
label: while i<count do INSERT INTO `simple`.`wu_person_t` (`ID`, `NAME`, `AGE`, `ADDRESS`, `DREAM`, `SEX`) VALUES (i, concat('李四001',i), '18', '日本', '航海家', 1);
set i =i+1;
end while label;
end $$
delimiter ;
call insertData(200000);