MySQL随机字符串函数是我们经常会用到的函数，下面就为您详细介绍该函数的语法，如果您对MySQL随机字符串函数感兴趣的话，不妨一看。

DROPFUNCTIONIFEXISTSrand_string; 
delimiter// 
CREATEFUNCTIONrand_string(l_numtinyintUNSIGNED,l_typetinyintUNSIGNED) 
RETURNSvarchar(127) 
BEGIN 
--Function:rand_string 
--Author:dbachina#dbachina.com 
--Date:2010/5/30 
--l_num:Thelengthofrandomstring 
--l_type:Thestringtype 
--1.0-9 
--2.a-z 
--3.A-Z 
--4.a-zA-Z 
--5.0-9a-zA-Z 
--<forexample>: 
--mysql>selectrand_string(12,5)random_string; 
--+---------------+ 
--|random_string| 
--+---------------+ 
--|3KzGJCUJUplw| 
--+---------------+ 
--1rowinset(0.00sec) 
DECLAREiintUNSIGNEDDEFAULT0; 
DECLAREv_charsvarchar(64)DEFAULT'0123456789'; 
DECLAREresultvarchar(255)DEFAULT''; 

IFl_type=1THEN 
SETv_chars='0123456789'; 
ELSEIFl_type=2THEN 
SETv_chars='abcdefghijklmnopqrstuvwxyz'; 
ELSEIFl_type=3THEN 
SETv_chars='ABCDEFGHIJKLMNOPQRSTUVWXYZ'; 
ELSEIFl_type=4THEN 
SETv_chars='abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; 
ELSEIFl_type=5THEN 
SETv_chars='0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; 
ELSE 
SETv_chars='0123456789'; 
ENDIF; 

WHILEi<l_numDO 
SETresult=concat(result,substr(v_chars,ceil(rand()*(length(v_chars)-1)),1)); 
SETii=i+1; 
ENDWHILE; 
RETURNresult; 
END; 
// 
delimiter;