—查询表的更新时间
SELECT
TABLE_NAME, UPDATE_TIME ,TABLE_COMMENT
FROM
information_schema.TABLES
WHERE
information_schema.TABLES.TABLE_SCHEMA = ‘city’
—查询表的更新时间
SELECT
TABLE_NAME, UPDATE_TIME ,TABLE_COMMENT
FROM
information_schema.TABLES
WHERE
information_schema.TABLES.TABLE_SCHEMA = ‘city’