给student表score字段设置60-100之间的数:

UPDATE `student` SET `field`=ceiling(rand()*60+40) WHERE id>0;