Get MySQL Table Creation Time.

How to check table create,update,check time in MySQL?

You can check table creation,update,check time for any table. Find below.

If you want to check the last update time or create time or last check time of table use following query for the above.

Syntax:- SELECT CREATE_TIME,UPDATE_TIME,CHECK_TIME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME='table_name' ;

Also you can check following for any table.

TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
ENGINE
VERSION
ROW_FORMAT
TABLE_ROWS
AVG_ROW_LENGTH
DATA_LENGTH
MAX_DATA_LENGTH
INDEX_LENGTH
DATA_FREE
AUTO_INCREMENT
CREATE_TIME
UPDATE_TIME
CHECK_TIME
TABLE_COLLATION
CHECKSUM
CREATE_OPTIONS
TABLE_COMMENT
TABLESPACE_NAME