Help Droplist

[Downwade]

Hello. I',m trying to remove all droplist from monsters, and i wanna to leave only Adena.

I tried like that -

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE itemid <> 57);

But not working for me. Maybe anyone can me explain how to make it?

[Downwade]

4 minutes ago, melron said:

Do you know how to execute commands?

 

You are saying is not working. Post your error then lol

I just downloaded your droplist and the command is working excellent..

 

Message:

[SQL]DELETE FROM droplist WHERE itemId <> 57

Affected rows: 25607
Time: 0.107s

 

For me not working, or i'm doing something wrong..

Edited July 30, 2018 by Downwade

[Downwade]

6 minutes ago, melron said:

 

Select your database, Click on the icon:

 

then press 'New Query' tool,

make sure the new tab of the query will have your database name after the @ like this

(sys is my db)

 

run the command by clicking Run tool , be happy

thank you a lot buddy!

[melron]

locked then

[HyperBlown]

This should be your command.

DELETE FROM droplist WHERE NOT itemId = 57