IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New MySQL != MS-SQL
But you could use that method to break the deletes up into chunks. Or you could add the selected IDs to a temp table and use that table in your in clause or do an inner join on it. I don't know which would perform best in your situation.

--
Chris Altmann
New D'oh. Missed that. Sorry.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.

     Bulk delete - (bluke) - (6)
         Partition the DELETE. - (static) - (2)
             MySQL != MS-SQL - (altmann) - (1)
                 D'oh. Missed that. Sorry. -NT - (static)
         Just throw the list in another table - (ChrisR) - (2)
             But won't I just be spending the time ... - (bluke) - (1)
                 If it's a one time event... - (ChrisR)

Ego cleanup on aisle three.
76 ms