MySQL – Generate random string

Have you ever wanted to generate a random string in MySQL, say for assigning a random password to a list of users? Well here is a useful tip!

bgfbgfgffsd

This creates a 6 character (easy to change, as you can see) string where the characters are from the MD5 command (and therefore in the range a-z and 0-9).

SOURCE

LINK (Thingy-ma-jig.co.uk)

LANGUAGE
ENGLISH