CREATE TABLE `t` (`id` int(11) NOT NULL,`a` int(11) DEFAULT NULL,`b` int(11) DEFAULT NULL,PRIMARY KEY (`id`), KEY `a` (`a`), KEY `b` (`b`)) ENGINE=InnoDB;
delimiter ;;
create procedure write_data()
begin
declare i int;
set i=1;
while(i<=10000)do
insert into t values(i, i, i);
set i=i+1;
end while;
end;;
delimiter ;
call write_data();
该存储过程会插入10000条数据到mysql中