展开全部
update 表名 set field2=switch(field1 >1000 and field1<=2000,1,
field1 >2000 and field1<=3000,2,
field1 >3000 and field1<=4000,3,
field1 >4000 and field1<=5000,4,
field1 >5000 and field1<=6000,5,
field1 >6000 and field1<=7000,6,
field1 >7000 and field1<=8000,7,
field1 >8000 and field1<=9000,8,
field1 >9000 and field1<=10000,9,
field1 >10000 and field1<=11000,10,
field1 >11000 and field1<=12000,11,
field1 >12000 and field1<=13000,12,
field1 >13000 and field1<=14000,13,
field1 >14000 and field1<=15000,14,
true,15)
就是用switch函数,相当于,如e69da5e887aa62616964757a686964616f31333332643838果field1 >1000 and field1<=2000 ,则field2=1,如果field1 >2000 and field1<=3000 ,则field2=2。。。。。。最后那个true就是,如果以上皆不是,则field2=15