DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2160;

Nao pega no xampp 1.6.5 ? ta dando esse erro aki

ELETE FROM player_depotitems,

player_items,

tile_items WHERE itemtype =7367

Mensagens do MySQL : Documentação

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = 7367' at line 1

Deve estar havendo alguma redundância na hora e o MySQL se recusa a fazer qualquer coisa que possa dar errado. Faça 3 queries:

DELETE FROM player_depotitems WHERE itemtype = 2160; DELETE FROM player_items WHERE itemtype = 2160; DELETE FROM tile_items WHERE itemtype = 2160;

  Em 18/12/2012 em 21:03, Lordfiree disse:

Deve estar havendo alguma redundância na hora e o MySQL se recusa a fazer qualquer coisa que possa dar errado. Faça 3 queries:

DELETE FROM player_depotitems WHERE itemtype = 2160; DELETE FROM player_items WHERE itemtype = 2160; DELETE FROM tile_items WHERE itemtype = 2160;

Funcionou +rep!

Duvida sanada

movido.