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

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / MySQL != MS-SQL
Post #171,630
by altmann
8/30/04 4:10:28 AM
Reply
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
Post #171,798
by static
8/30/04 9:53:08 PM
Reply
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) - Aug. 30, 2004, 02:21:16 AM EDT
         Partition the DELETE. - (static) - (2) - Aug. 30, 2004, 03:16:35 AM EDT
             MySQL != MS-SQL - (altmann) - (1) - Aug. 30, 2004, 04:10:28 AM EDT
                 D'oh. Missed that. Sorry. -NT - (static) - Aug. 30, 2004, 09:53:08 PM EDT
         Just throw the list in another table - (ChrisR) - (2) - Aug. 30, 2004, 10:39:32 AM EDT
             But won't I just be spending the time ... - (bluke) - (1) - Aug. 30, 2004, 10:41:15 AM EDT
                 If it's a one time event... - (ChrisR) - Aug. 30, 2004, 10:55:15 AM EDT

LYNX-tested and approved!
45 ms