How to get MySQL table creation date?

Question

I was wondering if it is possible to get the creation date of a particular table in the database. My employer would like to add this feature, and I could not find a solution with Google.

I realized that SO is the best place to watch.

Answer 1

You requested information_schema for the create_time table.

For example:

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

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

Answer 2

I know this is an old question, but I wanted to offer an alternative approach that does not involve directly querying the information_schema tables for those who are looking for this question later for reference.

You can get information about tables using "show table status". This gives you a lot of information, including the storage mechanism used, creation time, update time, and row count.

You can filter the results based on the table name, as shown below:

 show table status where name = 'your-table-name'