Bad Error

[Ferdek Kiepski]

mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 17 ORDER BY `time` LIMIT 1); - MYSQL ERROR: You can't specify target table 'player_deaths' for update in FROM clause (1093)

what this

 

[president vankk]

SQL Query:

DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 17 ORDER BY `time` LIMIT 1);

 

[tibiek]

not work error:

#1093 - You can't specify target table 'player_deaths' for update in FROM clause