mysql function 生成随机字符串

create function getString(length int)returns varchar(255)# BEGIN DECLARE i INT UNSIGNED DEFAULT 0; DECLARE v_result VARCHAR(200) DEFAULT ''; DECLARE v_dict VARCHAR(200) DEFAULT ''; SET v_dict = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'; SET v_dict = LPAD(v_dict,200,v_dict); WHILE i < length DO SET v_result = CONCAT(v_result,SUBSTR(v_dict,CEIL(RAND()*200),1)); SET i = i + 1; END WHILE; RETURN v_result; END