Don't know how to remove inserted objects from mysql
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); |
Quote:
[~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.] |
thanx
Cool thanx for the info, been stuck for awhile lol
|
Quote:
|
Navicat and now i have augs!
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 |
Augs work now? i havent tried in a few weeks, as far as i got was the insert but the aug never got attached.
|
Quote:
|
there are many mysql front ends that make editing a database easier. if you really wanna learn some basic sql though, read www.sqlcourse.com
|
Augments
Just got back on the boards, not quite sure how I got my augs but I Completely auged out my lvl 70 paladin with all effects attaching from the augs. Can't wait for the class aa's to work but the regular all class ones are good enough for now for my 0.7.0.
I'll look into the augs tommorow and see thecoding and stuff. |
DELETE FROM [tablename] WHERE [column name] = [value]
On another note, learn SQL. You won't be sorry. This stuff will just continue to invade our lives. I personally love databases. :) |
Thanx
Thanx for all the info :)
|
All times are GMT -4. The time now is 10:26 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.