Mysql获取表的创建时间和修改时间

jiawang

SELECT create_time 表创建时间,update_time 最后更新时间 FROM information_schema.tables WHERE table_schema = 数据库名 AND table_name = 表名 ;

mysql>  SELECT create_time,UPDATE_TIME FROM information_schema.tables WHERE table_schema ='ZFSOFT_YX' AND TABLE_NAME='YX_XTGL_XSLB';
+---------------------+-------------+
| create_time         | UPDATE_TIME |
+---------------------+-------------+
| 2020-08-17 10:25:53 | NULL        |
+---------------------+-------------+
1 row in set (0.07 sec)