List:General Discussion« Previous MessageNext Message »
From:Clyde Date:January 4 2003 9:45am
Subject:How to Unlock a row?
View as plain text  
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 (or
the connection is terminated). But how do you release these record locks if you do not
want to go ahead with the update.

Scenario:

User selects records to update.
User changes mind (clicks on cancel button)

Now we have locked rows that need to be unlocked.

How to do this?

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