SQL语句应用举例

1、修改物品堆叠数量

/*所有堆叠数大于1的改为9999*/
UPDATE item_template SET stackable = 9999 where stackable > 1 ; 

/*灵魂碎片堆叠数改为9999*/
UPDATE item_template SET stackable ='9999' WHERE ( entry ='6265') ; 

2、修改产量

/*剥皮最大产量改为20单位*/
UPDATE skinning_loot_template SET maxcount = 20 ; 

/* 钓鱼最大产量改为20单位*/
UPDATE fishing_loot_template SET maxcount = 20 ; 

/*采矿附产品（孔雀石、虎眼石、等）最大产量改为20单位*/
UPDATE prospecting_loot_template SET maxcount = 20 ; 

/*亚麻布、毛料、丝绸、魔纹布、符文布、恶魔布、灵纹布最大产量改为20*/
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='2589' ; 
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='2592' ; 
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='4306' ; 
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='4338' ;
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='14047'; 
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='14256';
UPDATE creature_loot_template SET maxcount ='20' WHERE item ='21877';

3、修改Gameobject刷新时间

/* 将id为XXX的gameobject刷新时间改为5秒，这里的id = gameobject_template.entry */
UPDATE gameobject SET spawntimesecs = 5 WHERE id = 'XXX'; 

4、修改药水冷却时间

 /* 将药水的冷却时间改为5秒*/
UPDATE item_template SET spellcategorycooldown_1 = 5000 where spellcategorycooldown_1 = 120000 and class = 0 ;

5、筛选特定的flags值

select * from item_template where flags & X = X

6、去掉特定的flags值

update item_template set flags = flags - 4096 where (flags & 4096) = 4096;