Fonction MySQL qui permet de generer une chaine de caractère aléatoirement

genstring.sql

/* Find on http://ready2gosoft.com/php/mysql-generate-random-string.html 
USE SELECT genstring(ROUND((RAND() * (128-1))+1));
USE SELECT CONCAT(genstring(ROUND((RAND() * (30-5))+5)), '@', genstring(ROUND((RAND() * (30-5))+5)), '.',  genstring(ROUND((RAND() * (5-2))+2)));

*/

DROP function if exists genstring;
delimiter $$
CREATE FUNCTION genstring(in_strlen int) RETURNS VARCHAR(500) DETERMINISTIC
BEGIN
set @var:='';
while(in_strlen>0) do
set @var:=concat(@var,ELT(1+FLOOR(RAND() * 26), 'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'));
set in_strlen:=in_strlen-1;
end while;
RETURN @var;
END $$