Need help with MySQL statement

Geesu · **Author**

Basically the select statement within this:

Code:

DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 10 DAY) > time ) )

will return rows... roughly 4000... But the delete statement will NEVER delete the data from wc3_player_race... I have NO idea why - anyone know how to make this work or another method to do it? I tried temporary tables as well (see comment here - there is also a DB dump if anyone wants to play with this)

TY!!!!!
Josh

slmclarengt · 12-12-2007 , 04:34 Re: Need help with MySQL statement

Quote:

Originally Posted by Geesu

Basically the select statement within this:

Code:

DELETE FROM wc3_player_race WHERE player_id IN ( SELECT `player_id` FROM `wc3_player` WHERE ( DATE_SUB(CURDATE(), INTERVAL 10 DAY) > time ) )

will return rows... roughly 4000... But the delete statement will NEVER delete the data from wc3_player_race... I have NO idea why - anyone know how to make this work or another method to do it? I tried temporary tables as well (see comment here - there is also a DB dump if anyone wants to play with this)

TY!!!!!
Josh

It seems like it did this for me:

Code:

Deleted rows: 842 (Query took 0.1250 sec)

Slmclarengt