danielcofour
Chieftain
- Joined
- Jan 25, 2014
- Messages
- 7
Basically what I want to do is something like this:
UPDATE Units SET Cost = Cost*0.7 WHERE EraType ='ERA_ANCIENT';
UPDATE Units SET Cost = Cost*0.6 WHERE EraType ='ERA_CLASSICAL';
UPDATE Units SET Cost = Cost*0.5 WHERE EraType ='ERA_MEDIEVAL';
etc...
Problem is: that won't work, since EraType is not a valid column for either Units or Buildings. I don't want to go through the entire list of units and adjust each of their costs manually, so my question would be can you achieve this somehow with SQL statements?
UPDATE Units SET Cost = Cost*0.7 WHERE EraType ='ERA_ANCIENT';
UPDATE Units SET Cost = Cost*0.6 WHERE EraType ='ERA_CLASSICAL';
UPDATE Units SET Cost = Cost*0.5 WHERE EraType ='ERA_MEDIEVAL';
etc...
Problem is: that won't work, since EraType is not a valid column for either Units or Buildings. I don't want to go through the entire list of units and adjust each of their costs manually, so my question would be can you achieve this somehow with SQL statements?