Call the date that table was created

0

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.

    
asked by anonymous 18.10.2018 / 15:49

1 answer

0

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

    
18.10.2018 / 15:55