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.


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:
> To unsubscribe:
Update table on lost connectionAlex Schaft28 Sep
  • Re: Update table on lost connectionHank28 Sep