DROP PROCEDURE IF EXISTS insertdata;
delimiter $$
create procedure insertdata()
begin
declare i int default 1;
DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;?
START TRANSACTION;
while i <= 2000000 do
insert into t_test_index(id,snumber,sname,sortFlag) values(UUID(),concat('XH2015-',i),concat('test-',i),i);
set i = i + 1;
end while;
COMMIT;
end $$
delimiter ;
call insertdata();
執(zhí)行時間：約 38s.73ms (除事務(wù)外，未進行調(diào)優(yōu))
