Defiant?
Does anyone know a quick way to remove all the defiant gear from the lootdrops?
|
SELECT le.* FROM items i
INNER JOIN lootdrop_entries le ON i.id = le.item_id WHERE i.name like "Crude defiant%" Change the WHERE clause to find the other types and just remove the rows all at once |
MySQL told me the first line has an error, it said:ERROR 1051 <42S02>: Unknown table "le"
|
It runs correctly for me, what MySQL program are you using? It works fine in Navicat.
|
i'm using the command prompt, I also have navicat though. Can you tell me how to run it in that?
|
Never mind I got it to work in command prompt mode :)
|
Well, I ran the query and it worked on stuff, but when I go into the lootdrop tables I still see the defiant stuff there :(
|
I ran it in HeidiSQL and just highlighted all the rows it selected and removed them all .. then do the next type of Defiant and so on.
|
Is there any way to change the value of a row in a query like the crude defiant to 0 without doing them all individually?
|
Quote:
|
Maybe if you had read and searched 1/8th as much as you just rapid fire questions (without thanking us), you would already know that.
I'll let Kingly give you your answer, since I really doubt you'll be able to peice it together just by looking at a few similar queries and seeing how the system even works. Easier to just keep having us do it right? |
Quote:
EDIT: Free handouts do ruin a community and create a rather large amount of people who are used to having things done for them, I admit that. I help those who can't help themselves, but when it gets out of hand I stop. |
I did it in heidiSQL, that's how i was able to remove them 1 at a time manually. I apologize for being so new at this, and if I forgot to thank you I apologize for that as well. Thank you all for your help!
|
You're welcome.
|
All times are GMT -4. The time now is 07:06 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.