Hello, I have an issue about finding the appropriate query to update a custom table via characters.
Actually i'm trying to Update `name` AND `race` from characters to my custom table via the Same player guid
so i tried several query like.
SET DataUP.name = characters.name,
DataUP.race = characters.race
WHERE characters.guid = DataUP.guid;
but nothing works anyone can help?
UPDATE DataUP SET `name`,`race` FROM characters WHERE DataUP.guid = characters.guid;