mysql 随机生成密码

DELIMITER $$

USE `ys`$$

DROP PROCEDURE IF EXISTS `pr_get_pwd`$$

CREATE DEFINER=`root`@`%` PROCEDURE `pr_get_pwd`(  )

BEGIN


SELECT REPLACE( GROUP_CONCAT(STR ),',','') pwd 
FROM (
	SELECT    CHAR(FLOOR(33+90*RAND())) STR 
	FROM  information_schema.`TABLES` a 
	
	LIMIT 12  
 ) T ;
 
 




END$$

DELIMITER ;