Antti Linno <[EMAIL PROTECTED]> writes:
> Is there any possibility to unlock tables after they've been locked? The
> manual part of lock was fuzzy, so I ask from experts instead. MySQL
> uses lock and unlock.
Locks are released at transaction commit/abort. It has to be that way
to preserve trans
Antti Linno wrote:
> Is there any possibility to unlock tables after they've been locked? The
> manual part of lock was fuzzy, so I ask from experts instead. MySQL
> uses lock and unlock.
Yes, COMMIT/ROLLBACK.
The transactional concept implies that you hold each lock you
accquired si