1.创建存储过程如下:
CREATE DEFINER=`属组名`@`%` PROCEDURE `test`(num int)
BEGIN
declare i int;
declare p char(11);
set i=0;
while i<num do
set p = concat ('1',substring(cast(3 + (rand() * 10) % 7 as char(50)), 1, 1),right(left(trim(cast(rand() as char(50))), 11), 9));
insert ignore into `属组名`.`table`(`号码字段`, `字段2`, `字段3`) values (p,'3',95);
set i=i+1;
end while;
END
2.调用存储过程:
CALL test(x); //x表示要生成的数据量