I was seeing this topic where it shows the last time the table was updated. Only I want to know when the table was created.
I was seeing this topic where it shows the last time the table was updated. Only I want to know when the table was created.
Almost same, only uses CREATE_TIME
instead of UPDATE_TIME
SELECT CREATE_TIME
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'dbname'
AND TABLE_NAME = 'tabname'
Reference in the MySQL documentation