Problemas con insert into

[rafaelrecarte]

Amigos tengo un formulario que me guarda valores numericos en my db, no se si es posible, pero quiero hacer un procedimiento almacenado que me sume todos esos valores y que al final me lo guarde en un campo que se llama 'calificacion'

Este es el código que tengo:

insert into wonderlic (calificacion)
values (r1+r2+r3+r4+r5+r6+r7+r8+r9+r10+r11+r12+r13+r14+r1 5+r16+r17+r18+r19+r20+r21+r22+r23+r24+r25+r26+r27+ r28+r29+r30+r31+r32+r33+r34+r35+r36+r37+r38+r39+r4 0+r41+r42+r43+r44+r45+r46+r47+r48+r49+r50)



y me aparece este error:

(insert into wonderlic (calificacion)
values (r1+r2+r3+r4+r5+r6+r7+r8+r9+r10+r11+r12+r13+r14+r1 5+r16+r17+r18+r19+r20+r21+r22+r23+r24+r25+r26+r27+ r28+r29+r30+r31+r32+r33+r34+r35+r36+r37+r38+r39+r4 0+r41+r42+r43+r44+r45+r46+r47+r48+r49+r50) as total, if((r1+r2+r3+r4+r5+r6+r7+r8+r9+r10+r11+r12+r13+r14 +r15+r16+r17+r18+r19+r20+r21+r22+r23+r24+r25+r26+r 27+r28+r29+r30+r31+r32+r33+r34+r35+r36+r37+r38+r39 +r40+r41+r42+r43+r44+r45+r46+r47+r48+r49+r50) as total;
/* Error de SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as total, if((r1+r2+r3+r4+r5+r6+r7+r8+r9+r10+r11+r12+r13+r14 +r15+r16+r17+r18+r19' at line 2 */
/* Affected rows: 0 Filas encontradas: 0 Advertencias: 0 Duración para 0 of 1 query: 0.000 sec. */)

Alguien que me auxilie, ya que no soy experto en mysql. Gracias