请教,这个SQL语句怎么写
在表A中,有字段:
name age sex salary bouns...
liu 25 male 2000
zhang 26 fmale 2200
wu 30 male 4000
........
我想给bouns字段赋值,其值等于相应salary值的1.5倍,请问该怎么写啊?效果如下
name age sex salary bouns...
liu 25 male 2000 3000
zhang 26 fmale 2200 3300
wu 30 male 4000 6000
.........