SELECT TABLE_NAME AS '表名', TABLE_ROWS AS '记录数', DATA_LENGTH/1024/1024 AS '表大小(MB)', CREATE_TIME AS '创建时间', TABLE_COLLATION AS '字符集'
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dingdingwork' ORDER BY TABLE_ROWS DESC
MySQL查询指定库中所有的表记录的行数,表的大小,创建时间,字符集
最新推荐文章于 2024-06-03 16:31:55 发布