This is Argyn's blog. I comment on topics of my interests such as software, math, finance, and music. Also, I write about local events in Northern Virginia, USA and all things related to Kazakhstan

Friday, September 04, 2009

Table creation date and time in MYSQL

If you need to lookup table creation date/time in MySQL database, it's in INFORMATION_SCHEMA.TABLES table. I used these fields today:
  • CREATE_TIME - date/time of table creation
  • DATA_LENGTH - table size in bytes
  • TABLE_ROWS - number of rows
Here's the description from documentation.

No comments: