+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Sql (/showthread.php?tid=3579)
- RiiOT - 02-28-2014
Hello guys i was wondering of theirs a sql code for this i am looking for.
Example theirs a item that needs item index "19" is their a replace sql code for this?
like to replace item index 19 in t_npc under a_item_1 (only) and it replaces all 19 with example 10?
Thanks.
- Nymphetamine - 02-28-2014
UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19
Or
UPDATE t_npc SET a_item_1 = 19 WHERE a_index = 19
That should work
- RiiOT - 02-28-2014
UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19
Or
UPDATE t_npc SET a_item_1 = 19 WHERE a_index = 19
That should work
UPDATE t_npc SET a_item_1 = 19 WHERE a_item_1 = 19
Has Worked 100% Thanks
- xMeowx3 - 02-28-2014
Hi.
As you got your answer, and your problem is solved, I am gonna move that topic to Solved section and mark it as solved.
Thanks,
-LCKB Staff