[blackdragonsdg]

You can mass assign loottables by zone using the following as long as the npc's follow the default numbering scheme.

This will set all npc's loottable_id in Plane of Knowledge(202) equal to X. The default starting point for npcid numbers is zoneidnumber * 1000. Generally the last npcid for any zone is ((zoneidnumber * 1000) +999).

update npc_types set loottable_id = X where id >= 202000 and id <= 202999;

There are probably other ways or even better ways to do this but I can't think of any atm.