Call the date that table was created

Asked

Viewed 24 times

0

I was watching this topical where it shows the last time the table was updated. Only I want to know when the table was created.

1 answer

0


Almost the same, just uses CREATE_TIME instead of UPDATE_TIME

SELECT CREATE_TIME
FROM   information_schema.tables
WHERE  TABLE_SCHEMA = 'dbname'
    AND TABLE_NAME = 'tabname'

Reference in mysql documentation

Browser other questions tagged

You are not signed in. Login or sign up in order to post.