如何获取 MySQL 表的创建日期？

要获取 MySQL 表的创建日期，请使用 information_schema。语法如下 -

SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'yourDatabaseName’ AND table_name = 'yourTableName';登录后复制

mysql> SELECT create_time FROM INFORMATION_SCHEMA.TABLES -> WHERE table_schema = 'business' -> AND table_name = 'student';登录后复制

+---------------------+ | CREATE_TIME | +---------------------+ | 2018-10-01 12:26:57 | +---------------------+ 1 row in set (0.12 sec)登录后复制

mysql> create table DateAsStringDemo -> ( -> YourDateTime datetime -> ); Query OK, 0 rows affected (0.57 sec)登录后复制

mysql> select now();登录后复制

+---------------------+ | now() | +---------------------+ | 2018-11-26 18:12:29 | +---------------------+ 1 row in set (0.00 sec)登录后复制

查询如下 -

mysql> SELECT create_time FROM INFORMATION_SCHEMA.TABLES -> WHERE table_schema = 'test' -> AND table_name = 'DateAsStringDemo';登录后复制

+---------------------+ | CREATE_TIME | +---------------------+ | 2018-11-26 18:01:44 | +---------------------+ 1 row in set (0.00 sec)登录后复制