You're right. But usually the WHERE column in the where clause is different from table to table so it isn't often you can do it that way.@Jonern
DELETE FROM player_depotitems WHERE itemtype = 2160;
DELETE FROM player_items WHERE itemtype = 2160;
DELETE FROM tile_items WHERE itemtype = 2160;
How about doing something similar to this:
DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2160;
Can't see why it shouldn't work as it works in the SELECT query to select items from several tables.
Triggers has been made to take care of that.Will this also delete all related records? In player item, depot item, etc?
Last edited: