Internal table fields

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Internal table fields

Post 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 :)
jamiel
Forum Contributor
Posts: 276
Joined: Wed Feb 22, 2006 5:17 am
Location: London, United Kingdom

Post by jamiel »

The MYI can give some of the details you are looking for.
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Post by alex.barylski »

I was hoping for something more PHP friendly, withut extenstions, etc...

A native function?? :P
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post by volka »

SHOW TABLE STATUS
returns `Create_time`, `Update_time`and many more.
Post Reply