Re: Function to show when a field's value was last updated
>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. MySQL doesn't store change histories. That's the job of the application software. PB -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.12.2/137 - Release Date: 10/16/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function to show when a field's value was last updated
news <[EMAIL PROTECTED]> 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 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function to show when a field's value was last updated
Unfortunately that would have to be designed into the system into a field. When updated, the instructions would be to instruct that field to update. Cheers Mark: > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Function to show when a field's value was last updated
Hi, 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. Thanks very much. Mark -- Fast, reliable, web hosting. http://www.loosesparks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]