DB Modification Date 1

[lvennard]

Can anyone tell me how (if its possible) to query the database and ask for its:
1: Table modification date
(the last time someone changed/add/deleted a table

2: Record modification date
(the last time someone changed/add/deleted data

I dont need both, but would prefer the record modification date. I'll take whatever I can get.

Im using php as my api, although that shouldn't make a difference. I can find it if you can give me the mysql function.

Thanks in advance!

 

[Bastien]

1. SHOW TABLE STATUS [FROM db_name]

Done on a table by table basis...I tend to use a loop to runt thru the tables

2. I usually make this part of the table structure, use a unix time value (seconds since the epoch) since the mysql date format for timestamp is occassionaly bothersome to work with...or more simple even is just using the timestamp column type



Bastien

Cat, the other other white meat

 

[lvennard]

Your right about messing with the time format... its never fun... but this works great anyway.
Thanks!