Simple Question: how to remove yield from tundra hills?

[Laz0r]

How do I remove a single production yield from specifically tundra hills? I'm not at all a modder and only know how to modify or repurpose lines from .sql files, so this is what I came up with to no success:

UPDATE Terrain_Yields
SET Yield = '-1'
WHERE TerrainType = 'TERRAIN_TUNDRA' AND 'REGION_HILLS' AND YieldType= 'YIELD_PRODUCTION';

 

[whoward69]

UPDATE Terrain_HillsYieldChanges
SET Yield=(SELECT Yield FROM Terrain_HillsYieldChanges WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION')-1
WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION';

 

[Laz0r]

UPDATE Terrain_HillsYieldChanges
SET Yield=(SELECT Yield FROM Terrain_HillsYieldChanges WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION')-1
WHERE TerrainType='TERRAIN_TUNDRA' AND YieldType='YIELD_PRODUCTION';

Thank you sir, by chance is there a guide somewhere on this forum for learning the different variables that can be changed in SQL files?

 

[whoward69]

SQLiteSpy 101

SQLiteSpy is a third party utility for executing SQL statements directly against an SQLite database (.db) file. This tutorial covers the basic use of this utility for testing Civ5 SQL statements outside of the game environment. First we need to download the utility Go to SQLiteSpy -...

forums.civfanatics.com