I am pretty sure you will need to make your client software do any updating you
require. Depending on the version of MySQL you are using you may be able to
achieve what you want by using a stored procedure that updates the timestamp
when you read the login information. Using a stored procedure would shift most
of the changes to the server.
John B.
-----Original Message-----
From: Urcid Pliego, Paulo [mailto:paul...@vw.com.mx]
Sent: Sunday, 2 April 2006 5:55 AM
To: win...@lists.mysql.com
Subject: Update timestamp with a select
Hi, does anyone know if it's possible for a timestamp column to
automatically update itself when a select is made? We have a
user/password/roles database that is accessed by Tomcat's j_security module
whenever a user logs into one of our webapps, and I want to know which users
haven't logged in recently so that I can erase their accounts. I would
appreciate all of your feedback on this one.
Thanks!
Paulo Urcid Pliego
E-Labor Producción DM e IM
Preserie y Construcción de Equipos
Volkswagen de México S.A. de C.V.
Teléfono +52 (222) 2 30 9961
Fax +52 (222) 2 30 6082
mailto:urc...@vw.com.mx
http://www.vw.com.mx
4 messages in com.mysql.lists.win32RE: Update timestamp with a select
