RE: Update timestamp with a select
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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:[email protected]] Sent: Sunday, 2 April 2006 5:55 AM To: [email protected] 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:[email protected] http://www.vw.com.mx -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]