问个关于列累加的问题。

Question

number1, number2, number3, number4......,number12
11       7        null     null
现在就是number3=number2+number1,number4=number3+number2,number5=number4+number3，就是等于前两列的相加。
难道只能一次次update吗？能不能一次性解决的？
多谢各位大大！

Answer 1

update tablename 
set number3=number2+number1,
    number4=2*number2+number1,
    number5=3*number2+2*number1,
    number6=5*number2+3*number1,
    number6=8*number2+5*number1,
    number7=13*number2+8*number1,
    number8=21*number2+13*number1,
    number9=34*number2+21*number1,
    number10=55*number2+34*number1,
    number11=89*number2+55*number1,
    number12=144*number2+89*number1