View Single Post
Old 04-25-2013, 03:46 PM  
KillerK
Confirmed User
 
Join Date: May 2008
Posts: 3,406
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
KillerK is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote