From: Hank Date: September 28 2011 1:32pm Subject: Re: Update table on lost connection List-Archive: http://lists.mysql.com/mysql/225851 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 >