MySQL Forums
Forum List  »  InnoDB

MySQL equivilent of Oracle NOWAIT FOR UPDATE
Posted by: Jared Cope
Date: September 21, 2005 11:05AM

Hi,

I was wondering if its possible for a transaction to detect that a row is already locked by another session and back out immediately, rather than waiting for the specified timeout in innodb_lock_wait_timeout. Oracle can do this with the NOWAIT FOR UPDATE clause, but I can't find the same for MySQL.

Any ideas?

Cheers, Jared.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL equivilent of Oracle NOWAIT FOR UPDATE
12199
September 21, 2005 11:05AM


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.