begin
declare chars_str varchar(62) default 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
declare return_str varchar(255) default '';
declare i int default 0;
while i<n do
set return_str=concat(return_str,substring(chars_str,floor(1+rand()*62),1));
set i=i+1;
end while;
return return_str;
end
相关文章
- 03-06String and Times
- 03-06【leetcode】438. Find All Anagrams in a String
- 03-06LeetCode 438. Find All Anagrams in a String
- 03-06如何在Spark SQL中的多个列上进行数据透视?
- 03-06python – PySpark:TypeError:condition应该是string或Column
- 03-06letecode [438] - Find All Anagrams in a String
- 03-06[LC] 438. Find All Anagrams in a String
- 03-06[哈希/滑动窗口] leetcode 438 Find All Anagrams in a String
- 03-06leetcode 438. 找到字符串中所有字母异位词(Find All Anagrams in a String)
- 03-06每日日报34——通过SQL语句将某个字段的括号给去掉