SQL Query Question

[jack-black]

I am trying to increase the EXP given by each mob x 15

So far I have this code

SELECT a_index
,a_exp*15 a_exp
from t_npc

 

It calculates the proper value but how do i get it to put that value into the table it just gives a result.

 

Just want a faster way to update the entire a_exp column by 15 rather than going thru with a calculator and entering manually

 

Thanks in advance