6/20/2006
MySQL RAND Function To Randomly Populate Table
MySQL’s RAND() function can be used to set random values or fill a table with random data.
The following SQL snippet will change column1 in all rows to a random number 0-50.
UPDATE tablename SET column1 = (rand() * 50)
Popularity: 24%
