Table creation time MySQL

Problem: To find table creation/modified time in a given database.

Solution: MySQL maintains table level audit information in data base 'information_schema' and in table 'TABLES' 

Below Query fetches information about table 'foo'

select * from information_schema.TABLES where TABLE_NAME='foo'