List:General Discussion« Previous MessageNext Message »
From:Hank Date:September 28 2011 1:32pm
Subject:Re: Update table on lost connection
View as plain text  
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 <alexs@stripped> 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=1
>
Thread
Update table on lost connectionAlex Schaft28 Sep
  • Re: Update table on lost connectionHank28 Sep