Thread: Flag large number random records in a MySQL database - one time only
View Single Post
  #2   IP: 112.87.30.158
Old 2015-04-19, 08:19 AM
Gann Valley Gann Valley is offline
初级会员
  
Join Date: 2013-04-11
Posts: 1
Gann Valley 现在声名狼藉
Default
You can use the following query:
Code:
UPDATE tableName SET win = 1 ORDER BY RAND() LIMIT 20000
Reply With Quote