这里列出一些数据库中插入10W条数据的代码:
1.sqlserver:
2.mysql(有点特殊,需要先创建一个存储过程,然后再调用):
3.oracle等待更新:
4.DB2等待更新:
1.sqlserver:
declare @i int
set @i = 1
while (@i<=50000)
begin
insert into t_brushCardHistory (iCardID,iCardTypeID,icard_head,iCardNO,iHostID,sHostAdd,tBrushTime)VALUES(2,1,0,1407062791,2,'主门口机',dateadd(minute,@i,getdate()))
set @i= @i +1
end
2.mysql(有点特殊,需要先创建一个存储过程,然后再调用):
DROP PROCEDURE if exists dowhile;
--
create PROCEDURE dowhile()
BEGIN
DECLARE i int DEFAULT 0;
START TRANSACTION;
WHILE i<100000 DO
insert into `TNt_telephone` (TNc_agencyName,TNc_phone,TNc_telePhoneOperator,TNc_operatTime,TNc_remark)VALUES(i,13380389053,'admin',now(),CONCAT('...阿狸',i));
set i=i+1;
END WHILE;
COMMIT;
END
--
call dowhile();
3.oracle等待更新:
4.DB2等待更新: