Don't know how to remove inserted objects from mysql

[Runeblade]

I inserted a forge with aug type capaibilties but i accidently placed it inside a wall and i dont know how to edit it or remove and replace it. Need some help :(.

Here was the code

NSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (5001, 152, '220', '90', '-55', '140', 17909, 0, 'IT66_ACTORDEF', 53, 1115);

[Angelox]

Originally Posted by Runeblade

I inserted a forge with aug type capaibilties but i accidently placed it inside a wall and i dont know how to edit it or remove and replace it. Need some help :(.

Here was the code

NSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (5001, 152, '220', '90', '-55', '140', 17909, 0, 'IT66_ACTORDEF', 53, 1115);

would it be DROP ? Anyways , go to MySQL web site, download and install MySQL Query Browser, It also points out command options , and helps you into how to use them, on the bottom , right-hand corner in the Syntax window.

[~RD~ Sorry to butt into this post instead of posting my own reply but I felt this is important enough it should be said here. The DROP command is not the correct command to remove data from a table. The DROP command is used to remove tables entirely, and can also remove your database entirely if given the right syntax.]

[Runeblade]

Cool thanx for the info, been stuck for awhile lol

[Angelox]

Originally Posted by Runeblade

Cool thanx for the info, been stuck for awhile lol

The best solution is to back up often - I have also installed "MySQL Administrator", it does back ups very well.

[Runeblade]

I downloaded Navicat for mysql found my entry ad edited the position a bit and now I can attach augs to my armor!!!!!!

WOOT WOOT

[njlinus]

Augs work now? i havent tried in a few weeks, as far as i got was the insert but the aug never got attached.

[Angelox]

Originally Posted by Runeblade

I downloaded Navicat for mysql found my entry ad edited the position a bit and now I can attach augs to my armor!!!!!!

WOOT WOOT

could you explain to us how you did this? thanks.

[Runeblade]

Thanx for all the info