How to set skill data

[Tryout]

How to set skill data same as starter skill data? Tried to create a query but it doesn't allow the where thing.

UPDATE cabal_new_character_data 
SET [SkillData]
= 0x02000100004D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F010151000100010100A501016600A601016700DA01016800E101016900E201016A00E301016B00
[COLOR=#ff0000]where[/COLOR] [ClassType] = 1

 

[PwrDex]

How to set skill data same as starter skill data? Tried to create a query but it doesn't allow the where thing.

UPDATE cabal_new_character_data 
SET [SkillData]
= 0x02000100004D01014600540101480055010149009001014B007C01014E007D01014F007E010150007F010151000100010100A501016600A601016700DA01016800E101016900E201016A00E301016B00
[COLOR=#ff0000]where[/COLOR] [ClassType] = 1

That should work, maybe you missed some synthax
recommend to avoid the usage of [] in sql, even by default it using it
UPDATE xy
SET SkillData = 0x
WHERE ClassType =1

Copy the error here if not resolved..

 

[monstrebel]

UPDATE cabal_new_character_data
SET SkillData = 0xblablabla
where ClassType = 1