随机字符串
SET @randomString = MD5(RAND());
截取字符串
SET @newString = SUBSTRING(@randomString, 1, 32);
从第一个位置开始截取,截取到第32个长度
转成大写
SET @upperString = UPPER(@newString);
转成小写
SET @lcaseString = LCASE(@upperString);
SET @randomString = MD5(RAND());
SET @newString = SUBSTRING(@randomString, 1, 32);
从第一个位置开始截取,截取到第32个长度
SET @upperString = UPPER(@newString);
SET @lcaseString = LCASE(@upperString);
还不快抢沙发