Create Random Password

Submitted by:Jhon Smith

Date added:01 September, 2014

Category:MySQL

MySQL code example to assign random passwords

Tags: random password , create password

Code Snippet:

CONV(FLOOR(RAND() * 99999999999999), 10, 36)

INSERT INTO uscr_users
( email, item_id_list, login_name, pword)
SELECT contact_email, item_id, item_contact_name,
CONV(FLOOR(RAND() * 99999999999999), 10, 36)
FROM item_data
WHERE item_contact_email <> ''
AND item_contact_name <> '' LIMIT 3;
 
 

Comments