Update all rows with random string every month using mysql

Question

I am trying to create a mysql event that updates all rows with a random string every month. The string doesn't have to be unique.

CREATE EVENT IF NOT EXISTS `new code`
ON SCHEDULE EVERY '1' MONTH
??
UPDATE table
SET code = "rand(?)"

I have no idea how to do the rest!

Cool! Now I got the update function working. How do I make this run every month? — prince888, Oct 09 '15 at 17:36
Make sure event scheduler is enabled https://dev.mysql.com/doc/refman/5.6/en/create-event.html — Mihai, Oct 09 '15 at 17:38

score 1 · Answer 1 · edited Oct 10 '15 at 05:01

1

Try using the MD5 function to convert a random number into a string:

SET code = MD5(RAND())

edited Oct 10 '15 at 05:01

Chuck

answered Oct 09 '15 at 17:36

DISEQBLIURM

1 Answers1