一个存储过程用于生成模拟数据

begin
DECLARE v1 INT DEFAULT 100000;
delete from person;
  WHILE v1 > 0 DO
	insert into person(name,age) values(CONCAT("person",v1),rand()*100);
    SET v1 = v1 - 1;
  END WHILE;
end