DELETE FROM bd_action WHERE (SELECT bd_action,bd_target,SUM(bd_count) AS bd_count,bd_data FROM bd_action GROUP BY CONCAT(bd_data,bd_action,bd_target LIMIT 10000) )
I would try that?
Also, copy the table to a new table, and try running it against that one first.
Otherwise, you can do it with php
|