Logo testarei todos

Esses dois códigos estão com erro cara.. Eu testei aqui.

 

tente executar os códigos separados.

DELETE FROM players WHERE id > 1

e

DELETE FROM player_death

DELETE FROM player_depotitems

DELETE FROM player_items

DELETE FROM player_killers

DELETE FROM player_skills

DELETE FROM player_spells

DELETE FROM player_storage

DELETE FROM player_viplist

tente executar os códigos separados.

DELETE FROM players WHERE id > 1

e

DELETE FROM player_death

DELETE FROM player_depotitems

DELETE FROM player_items

DELETE FROM player_killers

DELETE FROM player_skills

DELETE FROM player_spells

DELETE FROM player_storage

DELETE FROM player_viplist

 

Logo quando eu tento executar a primeira Query, da isso:

Error while executing query: foreign key constraint failed

o meu deu o mesmo erro que o acima

DELETE FROM `players` WHERE NOT `players`.`name` IN ("Account Manager", "Rook Sample", "Sorcerer Sample", "Druid Sample", "Paladin Sample", "Knight Sample");