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 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
> mul
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
