[MySQL] Removing spellcost

[Kirsebaer]

If I want to change all spellcosts in trainer_spells to 0, how should I make the SQL file?

[stoneharry]

UPDATE `trainer_spells` SET `spellcosts` = '0';

[Kirsebaer]

It did not work :0
1054 - Unknown column 'spellcosts' in 'field list'

[stoneharry]

It did not work :0
1054 - Unknown column 'spellcosts' in 'field list'

Change it to the correct column then? Common sense.

Go intro trainer_spells table, look for what the cost column is called, change it in query, re-execute...