Page 1 of 1

Internal table fields

Posted: Sat Jul 29, 2006 7:40 pm
by alex.barylski
I'm wondering if MySQL and/or others keep internal variables fo each table and/or each record in a DB...

For instance, is there a MySQL internal variable which you can access, through undocumented API or something which allows you to view which time a MySQL table might have created or modified?

I imagine there must be something like this, but of course I cannot find anything on it...

Also if there is a timestamp for tables, do other databases support this as well???

Cheers :)

Posted: Sat Jul 29, 2006 7:52 pm
by jamiel
The MYI can give some of the details you are looking for.

Posted: Sat Jul 29, 2006 9:02 pm
by alex.barylski
I was hoping for something more PHP friendly, withut extenstions, etc...

A native function?? :P

Posted: Sun Jul 30, 2006 3:36 am
by volka
SHOW TABLE STATUS
returns `Create_time`, `Update_time`and many more.