56,677
社区成员
发帖
与我相关
我的任务
分享
BEGIN
set session autocommit=0;
truncate table t1;
set @starttime = unix_timestamp(current_timestamp());
set @i = 0;
set @num = 10000;
while @i<@num do
insert into t1(id1,id2,content) values(@i,@i,'aaa');
set @i = @i +1;
end while;
commit;
set @endime = unix_timestamp(current_timestamp());
select @endime - @starttime;
END