Wrong query or not

[Uthil 216]

So, I'm trying to update on the creatures_template table some columns, but when I'm using the update query for the column 'rank' I have the issue that it is recognized as a command and not as the columns, mean that HeidisSQL turns the word “rank” on blue and capital. 

Do I have any other choice on that, or I have to change by hand the values on rank column by my self? 

[Atraxian 50]

Try something like this:
UPDATE `creature_template` SET `rank` = 2 WHERE (`entry` = 5291);
Using    `    at the start and end of rank should make HeidiSQL recognize it as a column name and not as a command.

Note that ` is a special character and not an apostrophe like ' (I know, the difference is hard to see, but if you use an apostrophe, heidisql will recognize the text as a string), an easy way to have it at the ready if your keyboard doesn't have it is to copy and paste it in a document and bring it up whenever you need it

It looks like this:

[Uthil 216]

Yeah, I think which one you're talking about, it's on the first key before the number one, if you press shift and that key you will get the wave thing dash. I'm gonna give it a try. Thanks though for the information.

[Atraxian 50]

Sadly, the italian keyboard has a different layout and we don't have that key (instead we have \ | on the left of 1).
in case you aren't already using it, Keira3 is a great tool for editing creatures or game objects one by one.
https://github.com/azerothcore/Keira3

[Uthil 216]

9 hours ago, Atraxian said:

Sadly, the italian keyboard has a different layout and we don't have that key (instead we have \ | on the left of 1).
in case you aren't already using it, Keira3 is a great tool for editing creatures or game objects one by one.
https://github.com/azerothcore/Keira3

Nope, I haven't got yet time to edit again the DB. But hell, this is amazing, an amazing tool also like GitHub - NotCoffee418/TrinityCreator: This tool allows you to easily create items, creatures and quests for TrinityCore 3.3.5a. Hopefully works also with A.C version as it author mentions, which seems to be another GODlike tool. Yet need some time to check those tools, I only started to edit DB, few entries to see how it goes.  Anyway, thanks once more.

[Furioz 32]

22 hours ago, Uthil said:

Nope, I haven't got yet time to edit again the DB. But hell, this is amazing, an amazing tool also like GitHub - NotCoffee418/TrinityCreator: This tool allows you to easily create items, creatures and quests for TrinityCore 3.3.5a. Hopefully works also with A.C version as it author mentions, which seems to be another GODlike tool. Yet need some time to check those tools, I only started to edit DB, few entries to see how it goes.  Anyway, thanks once more.

Since you are working with AC, you probably preffer Keira 3.

https://www.azerothcore.org/Keira3/

This is like the tool u mentioned above, but this one is made and maintained by the AC community.
Feel free to ask any questions in their discord.
Azerothcore Discord