Update table on lost connection

[Alex Schaft]

Hi,

We're busy moving legacy apps from foxpro tables to mysql. User logins 
were tracked via a record in a table which the app then locked, 
preventing multiple logins for the same user code.


I want to simulate this via a locked column in a mysql table, but 
would need the field to be cleared if the server loses the connection to 
the client. How would I do this, or is there an alternative?


Thanks,
Alex



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Update table on lost connection

[Hank]

Check out the GET_LOCK and RELEASE_LOCK virtual lock functions in MySQL.

-Hank



On Wed, Sep 28, 2011 at 9:15 AM, Alex Schaft al...@quicksoftware.co.za wrote:
 Hi,

 We're busy moving legacy apps from foxpro tables to mysql. User logins were
 tracked via a record in a table which the app then locked, preventing
 multiple logins for the same user code.

 I want to simulate this via a locked column in a mysql table, but would
 need the field to be cleared if the server loses the connection to the
 client. How would I do this, or is there an alternative?

 Thanks,
 Alex




 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:    http://lists.mysql.com/mysql?unsub=hes...@gmail.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org