OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Function to show when a field's value was last updated

Alec.Cawleyquantel.com
Date: Tue Oct 18 2005 - 05:20:22 CDT


news <newssea.gmane.org> wrote on 17/10/2005 15:45:15:

> I need it some info to help a client defend against a legal challenge.
> Is there a MySQL function that will allow me to ascertain the date and
> time that a particular field's value was last updated. I can't find
> anything in the MySQL documentation.

It is almost certainly not possible. If you look in the manual for the
storage space occupied by each field, you will see there is no space to
store any form of timestamp. Since MySQL does not store the data you want,
it cannot extract it for you.

        Alec

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql