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:
> 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?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1