Example of how to generate a random string in MySQL.

select SUBSTRING(MD5(RAND()) from 1 for 6) as randomstring;