[HELP]Navicat Sql

[Zoubis®™]

Hi...

tha hthela an mporousate na m vreite ton code tou sql p diagrafei mazika to id p tha tou valeis...

nomizw paei kapws etC : Delete where id..

Thx :)

[Fanky]

τι ακριβώς θες να σβήσεις και από πού?

παράδειγμα,άμα είναι από άλλο table άλλαξε το droplist,και το item type κάντο replace με το spelbook

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spelbook' );

[Zoubis®™]

apo to spawnlist kapia mobs alla einai pola...opote thumithika oti uphrxe auto to code :)

ktlves? :P

[Fanky]

ορίστε

DELETE FROM spawnlist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'L2Monster' );

και βάζε τα type των κάθε mob που θές

[Zoubis®™]

DELETE FROM spawnlist WHERE itemid 20192

auto as poume?

 

[Fanky]

DELETE FROM spawnlist WHERE itemid 20192

auto as poume?

 

όχι ρε,κάθε mob έχει και ένα type το type του mob βάζετο

DELETE FROM spawnlist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= '[color=Red]εδώ[/color]' );