Add Random Hashes With Mysql

Adding a new column to a table which needs to contain a different random hash for each row?

Mysql can easily generate md5 strings and update all rows in the table for you

UPDATE thetable
SET thecolumn = MD5(RAND())
WHERE thecolumn IS NULL

Posted by at 9:37 am on November 1st, 2011.
Categories: MySQL.