UPDATE `kingdom`.`monsterinfos` SET `PlusCps` = `PlusCps`/10
on table monsterinfos how to set all pluscps records to itself/10 on navicat console.
Advertisement
Answer
Thank you all I found it XD its so simple
UPDATE monsterinfos SET PlusCps=PlusCps/10;