Snippet Name: Create Random Password
Description: Assign random passwords with a simple mySQL statement.
Comment: (none)
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; |
