mysql数据库使用存过向表中插入含不重复手机号的数据

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表示要生成的数据量