MySQL Forums
Forum List  »  InnoDB

Locks in a InnoDB table
Posted by: Yogesh Mahadnac
Date: December 30, 2004 08:30AM

Hi!

I have a question for you.
The thing is, I don't understand how to release the lock after the transaction is completed.

For example, 1 user calls a particular reservation number for update (e.g. reserNo 1). He inputs the number in the text field provided.
Normally when this happens, I select * from reservation where resaNo = theNumberInput

Now assuming that a second user wants to view the details of the same reservation number. I don't want the second user to be able to make changes on that particular reservation until the 1st user has finished.

How do I proceed using InnoDB Locks?

Thanks and regards

Yogesh Mahadnac

Options: ReplyQuote


Subject
Views
Written By
Posted
Locks in a InnoDB table
3410
December 30, 2004 08:30AM
2836
December 30, 2004 07:58PM
2524
January 01, 2005 05:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.