On Mon, 02 Apr 2001, Richard Ellerbrock wrote:
> From the manual:
>
> If you are using FOR UPDATE on a table handler with page/row locks, the examined
>rows will be write locked.
>
> I agree that this does not tell me much. When are the rows unlocked?
>
educated guess....
select for update only makes sense within transactions so logically the records
would be locked until the transaction completes (commits) or fails.
Nigel
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
