1.将一张表中的数据范围在20-29的改为20,30到39的改为30 update stu set number=floor(number/10)*10 where number between and 20 and 39;