晨风

-------------------- 业精于勤,荒于嬉;行成于思,毁于随

导航

mysql随机数

Posted on 2020-03-23 14:56  shenyixin  阅读(240)  评论(0编辑  收藏  举报
DELIMITER $$
CREATE DEFINER = `root` @`localhost` FUNCTION `func_range_string_mod` ( f_num INT UNSIGNED -- Total strings.
) RETURNS VARCHAR ( 200 ) CHARSET latin1 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 < f_num DO
        
        SET v_result = CONCAT( v_result, SUBSTR( v_dict, CEIL( RAND( ) * 200 ), 1 ) );
    
    SET i = i + 1;
    
END WHILE;
RETURN v_result;

END $$DELIMITER;
SELECT func_range_string_mod(6);