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.
Subject
Views
Written By
Posted
MySQL equivilent of Oracle NOWAIT FOR UPDATE
12199
September 21, 2005 11:05AM
5728
September 21, 2005 11:59AM
5165
September 22, 2005 04:09AM
4102
September 22, 2005 12:59PM
3831
September 23, 2005 03:06AM
4142
September 23, 2005 07:14AM
4369
September 22, 2005 04:36AM
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.