今天在做测试的时候需要用到大量的测试数据,于是就写了两个函数用于生成随机姓名和手机号的,在这里记录一下
随机生成手机号:generatePhone()
CREATE DEFINER=`root`@`%` FUNCTION `generatePhone`() RETURNS char(11) CHARSET utf8
DETERMINISTIC
BEGIN
DECLARE head VARCHAR(100) DEFAULT '000,156,136,176';
DECLARE content CHAR(10) DEFAULT '0123456789';
DECLARE phone CHAR(11) DEFAULT substring(head, 1+(FLOOR(1 + (RAND() * 3))*4), 3);
#SET phone = CONCAT(phone, substring('156,136,123,456,789', 1+(FLOOR(1 + (RAND() * 4))*4), 3));
DECLARE i int DEFAULT 1;
DECLARE len int DEFAULT LENGTH(content);
WHILE i 0.400 THEN
SET return_str = CONCAT(return_str, substring(ming, floor(1 + RAND() * I_ming), 1));
END IF;
RETURN return_str;
END
|