try
delete ... limit n;
where n is a reasonable (small) amount. repeat until 0 rows affected :)
- Original Message -
From: "Basil Hussain" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, March 29, 2001 7:10 PM
Subject: Question a
Hi,
There's something I'm not sure about with DELETE LOW_PRIORITY. It says in
the manual that:
"If you specify the keyword LOW_PRIORITY, execution of the DELETE is delayed
until no other clients are reading from the table."
What exactly does it mean by "no other clients are reading"? Does it me