How do I get the creation date of a MySQL table? [duplicate]

You would query the information_schema for the create_time of the table.

For instance:

SELECT create_time FROM INFORMATION_SCHEMA.TABLES
  WHERE table_schema="your_schema"
  AND table_name="your_table"

Reference: http://dev.mysql.com/doc/refman/5.0/en/tables-table.html

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)