[Help] Navicat - SQL

[Zudrik]

Alright, so I have a server up and running, everythings working fine. The problem is, however, that I want to be able to delete or modify an SQL entry that I already executed in to the database.

It's my teleporter, I want to change the display ID and scale. I tried looking through the creature_proto and creature_names, couldn't see my teleporter.

If anyone could shed some light on how I can do this, or if it's even possible, I would greatly appreciate it.

Thank you,
Zudrik

[gangstagreen]

re-execute the bach file and look for it again, if that fails...

[Zudrik]

Can't, since it's a duplicate. I mean I even get the same problem with items.

Ctrl + F, type in the name, entry ID, nothing works, lol.

[TheSpidey]

Try using SQL statements.

[Zudrik]

I figured it out, lol thanks guys =D

[gangstagreen]

I figured it out, lol thanks guys =D

For future refrences, please state how you fixed it

[kreegoth]

FOr duplicate things next time just Change INSERT INTO to REPLACE INTO and itll overwrite it.. Or next time if you know the Npc's id use a Query such as

Select * from `creature_proto` where `entryid` = 'NPCID'

and itll just find that ID for you

[Quackamolian]

Zudrik, could you please state how you fixed this? Other people (such as me, lol) find it helpfull to know how it was fixed. I have the same problem. Could you post how you fixed it?