淡泊以明志,宁静以致远

摘要： BEGIN #遍历占领野地表还原军队 #update armforce set number=num where troopsid=(select id from troops where isfrist=1 and cityid=cityid) DECLARE tId DECIMAL(21,0) default -1;#occupyWild表的TroopsId DECLARE cid DECIMAL(21,0) default -1;#occupyWild表的CityId DECLARE temp_tId DECIMAL(21,0) default -1;#occupyWild表的TroopsId DECLARE temp_cid DECIMAL(21,0) default -1;#occupyWild表的CityId DECLARE tId2 DECIMAL(21,0) default -1;#troops表的TroopsId 阅读全文