Log in

View Full Version : Update random dates in MYSQL table

Inger
2015-04-19, 06:35 AM
UPDATE randomdate SET randomdate= DATE_SUB(CURDATE(),INTERVAL RAND()*365 DAY);