一、python环境下 使用循环和随机数造数
>>> fp=open("e:\abc\1.txt","w")
>>> for i in range(50):
... fp.write(str(random.randint(13500000000,13999999999))+"
")
...
>>> fp.close()
二、用存储过程,造测试数据
-
drop procedure if exists copy_task_proc;
create procedure copy_task_proc
as
begin
Declare @i int
set @i=0;
while @i<10
do
-- 要执行的SQL语句
-- 复制当前表的数据,插入到当前表
insert into jcp_sys.Global_Users set(Userid,mail,tel)values( “333”+@i,’188888888@qq.com’,’188888888’)
set @i=@i+1;
commit;
while;
end;
-- 调用存储过程
exec copy_task_proc;
-- 统计数据
select count(*) from Global_Users;
存储过程实践:
DELIMITER //
CREATE PROCEDURE proc21()
BEGIN
DECLARE k INT;
SET k = 10;
truncate table index_user;
set autocommit=0;
set unique_checks=0;
WHILE k < 100 DO
INSERT INTO
`index_user`
(
`id`,
`name`,
`email`,
`mobile`,
`submission_date`
)
VALUES (
k,
concat(k,'tester'),
concat(k,'tester@qq.com'),
15000000000 + k,
now()
);
SET k = k + 1;
END WHILE;
set autocommit=1;
set unique_checks=1;
END
//
DELIMITER ;
call proc21();
CREATE PROCEDURE proc21()
BEGIN
DECLARE k INT;
SET k = 10;
truncate table index_user;
set autocommit=0;
set unique_checks=0;
WHILE k < 100 DO
INSERT INTO
`index_user`
(
`id`,
`name`,
`email`,
`mobile`,
`submission_date`
)
VALUES (
k,
concat(k,'tester'),
concat(k,'tester@qq.com'),
15000000000 + k,
now()
);
SET k = k + 1;
END WHILE;
set autocommit=1;
set unique_checks=1;
END
//
DELIMITER ;
call proc21();