sql插入10万数据怎么写

[wwf06802136]

sql插入10万数据怎么写？随便插一个表，要mysql和MsSql的

[lovezx1028]

while i<=100000
insert into tableName ...

[sb3day]

insert tb
select 1
go 100000

[bancxc]

while i<100000
insert

[永生天地]

sqlserver

declare @i int
set @i=1
while @i<=100000
begin
	insert into tb(id,value) values(@i,'item'+ltrim(@i))
	set @i=@i+1
end

select * from tb

[永生天地]

mysql

DECLARE v1 INT DEFAULT 5;
WHILE v1 <= 100000 DO
    insert into tb(id,value) values(v1,'item'+ltrim(v1));
    SET v1 = v1 + 1;
END WHILE;

[永生天地]

default 写错了

[htl258_Tony]

SQL：

--> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
	DROP TABLE [tb]
GO
CREATE TABLE [tb] (id [int] identity,[col] [nvarchar](10))
GO
insert tb 
select 1 
go 100000

select * from tb

[zhouwei7682719]

while i<100000
insert

[LiveCoach]

declare @i int
set @i=1
while @i<=100000
begin
insert into tb(id,value) values(@i,'item'+ltrim(@i))
set @i=@i+1
end

select * from tb

[沐心月儿]

插入式的

[leeyihan]

10w条，得用 bulk insert 了，要不慢死你。

自己baidu一下吧。

[shen258cscs]

 select 

[gw6328]

create table t(id int identity,c varchar(100));

go

insert into t select NEWID()
go 1000

select * from t;