+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: SQL Query Question (/showthread.php?tid=237)
- jack-black - 10-10-2011
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