List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 5 2003 12:49am
Subject:Re: How to Unlock a row?
View as plain text  
At 7:07 +0800 1/5/03, Clyde wrote:
>Clyde,
>
>----- Original Message -----
>From: ""Clyde"" <clyde@stripped>
>Newsgroups: mailing.database.mysql
>Sent: Saturday, January 04, 2003 11:47 AM
>Subject: How to Unlock a row?
>
>
>>  Hi,
>>
>>  Using MySql with InnoDB files you can lock rows for update.
>>  Eg select * from customer where cusomerID=1 for update
>>
>>  I assume these locks are release when the the records selected are
>actually updated
>
>>no.
>
>Does this still hold true if MySql is running in autocommit mode?
>
>And therefore does the query "select * from customer where 
>cusomerID=1 for update" only make sense to use if autocommit is OFF? 
>IE if Autocommit is on, and you run this query, are the records 
>still locked, or has an implicit COMMIT been issued because we are 
>running in autocommit mode - thus releasing the record lock.

The latter.  In auto-commit mode, each statement is its own transaction.

>
>
>Thanks
>Clyde

Thread
How to Unlock a row?Clyde4 Jan
  • re: How to Unlock a row?Victoria Reznichenko4 Jan
Re: How to Unlock a row?Heikki Tuuri4 Jan
Re: How to Unlock a row?Clyde5 Jan
  • Re: How to Unlock a row?Paul DuBois5 Jan