hidden timestamp?

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

this is regarding mysql. sorry if this is in the wrong section. ive overlooked putting a timestamp column in a table. is there any way where i can retrieve any kinda hidden timestamp values associated with each row in the table? basically i want to pinpoint the time when a particular transaction was made into the table, eg, an insert sql. thanx.

Comment on hidden timestamp?

Replies are listed 'Best First'.
Re: hidden timestamp? by BlacKat (Novice) on Feb 14, 2003 at 08:05 UTC
As far as I know the only information you can get from your table is that information that is inserted into it. Unfortunatly, this means that there is no record of when rows were added to the table unless you provided that information when the insert was done via a timestamp column. I could be wrong, however, I am pretty certian there is no way to determine when individual rows were added to a table unless you add that information yorself. Sorry!	[reply]
Re: hidden timestamp? by extremely (Priest) on Feb 14, 2003 at 19:04 UTC
There is no hidden timestamp. If it is really critical, you might be able to figure them out from your webserver logs, or possibly your tcpd logs if it was non-local. Beyond that, you are outta luck. :( -- $you = new YOU; honk() if $you->love(perl)	[reply]