The GET_LOCK() and RELEASE_LOCK() functions might help you,
if
you need this feature enough to build it yourself.
Cheers,
Kent Hoover
Feed the filter: database, query
-
Before posting, please check:
ok... ??
Patrick
# -Original Message-
# From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
# Sent: Friday, May 04, 2001 3:39 AM
# To: [EMAIL PROTECTED]
# Subject: RTFM - Show locks
# Importance: High
#
#
# database, sql
#
# Hi there
#
# I have tried looking in the manual but can't
database, sql
Hi there
I have tried looking in the manual but can't see the solution to this.
user a issues a lock on table1, userb then tries to do a select and
obviously the select will wait until the lock is released.
So my questions are :-
1. How do you change the 'timeout' period that