MySQL Table, Database - Creation Time

MySQL Table, Database - Creation Time
Have you ever wanted to know the creation time of a mysql table? You may sometime wanted to know the creation time of the mysql table.

You can get the creation time of a table by executing the following query as "root" user in mysql

mysql> select table_schema, table_name, create_time from information_schema.tables;

Usually "information_schema" database contains the information about the schema, tables, routines, stored procedures, views created in your mysql server.

You can explore more information about "information_schema" database by executing the following query:

mysql> show tables from information_schema;

The above will get you the list of tables available in information schema, you can get more information by putting a select query on each table.