How to create a random string of text with mysql ?07.12.13

to generate a random string with with mysql you can execute this mysql command : UPDATE `table` SET col = (SELECT concat( ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ), ELT(FLOOR(1 + (RAND() * (50-1))), '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', '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' ) ) ) WHERE condition=TRUE; 07.12.13

http://forums.devarticles.com/mysql-development-50/random-string-in-mysql-89293.html

Another solution

SELECT CONCAT( SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1), SUBSTRING('ABCDEFGNIJKLMNOPQRSTUVWXYZabcdefghijlkmnopqrstivwxyz',FLOOR(1 + RAND() * 51),1) ) as Foo; 07.12.13

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024