Update table on lost connection

--------------080600000601080104060301
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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



--------------080600000601080104060301
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--------------080600000601080104060301--

Re: Update table on lost connection

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 wr=
ote:
> Hi,
>
> We're busy moving legacy apps from foxpro tables to mysql. User logins we=
re
> 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dheskin@gmail.=
com
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg