阿里云wordpress建站/海外营销推广

 快速生成100W条数据，生成的时候是顺序生成，取的时候是随机取用，生成100W条数据大概一分多钟，比网上其他代码速度要快很多

CREATE TABLE tb(id char(6))--truncate table tb
--select top 1 id from tb order by NEWID()
--select ID from tb where id ='190300'select COUNT(1) from tbSET NOCOUNT ON;declare @i int = 0
while @i<10000
begin
insert into tb(id) values( cast(RIGHT(100000000 + CONVERT(bigint, @i), 6) as varchar(6)))
set @i=@i+1
enddeclare @n int =0
while @n<9
begin
set @n=@n+1
insert into tb
select '0'+CAST(@n as char(1))+SUBSTRING(ID,3,4) from tb where ID<'010000'
waitfor delay '00:00:01'
enddeclare @m int =0
while @m<9
begin
set @m=@m+1
insert into tb
select CAST(@m as char(1))+SUBSTRING(ID,2,5) from tb where ID<'100000'
waitfor delay '00:00:01'
endselect COUNT(1) from tb