Thanks alot..i have implemented in same format.You people are awesome.Thank You once again
On Tue, Apr 8, 2014 at 8:58 PM, Hannes Erven <hannes@xxxxxxxx> wrote:
Hi,
On 2014-04-08 15:27, Vick Khera wrote:
[...]In fact, you can: use "FOR UPDATE NOWAIT" and catch any errors.
Problem 2: you cannot have a second process skip over locked rows.
e.g. SELECT * FROM jobqueue WHERE id=? FOR UPDATE NOWAIT
-hannes
K.Santhosh Kumar
Member of Technical Staff
Groupon,Chennai
