CoderZone.org

Category: >> mySQL >> Create Random Password Bookmark and Share

<< lastnext >>

Snippet Name: Create Random Password

Description: Assign random passwords with a simple mySQL statement.

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: February 28th, 2009

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;
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7