Tables are locked on delete because, like an update, they are changing data.
Imagine issuing a REPLACE statement after a DELETE statement. If the DELETE locks the table, then the REPLACE happens AFTER the DELETE, as you wanted. If the DELETE does not lock the table, then it's possible the REPLACE will happen before the DELETE, and the DELETE will delete the row you just replaced. -Sheeri On 2/9/06, Ady Wicaksono <[EMAIL PROTECTED]> wrote: > Why table locked on delete? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
