https:\/\/www.cnblogs.com\/lyc94620\/p\/10114365.html<\/p>\n
SELECT TABLE_NAME AS ‘\u8868\u540d’,
\nCONCAT(ROUND(TABLE_ROWS\/10000, 2), ‘ \u4e07\u884c’) AS ‘\u884c\u6570’,
\nCONCAT(ROUND(DATA_LENGTH\/(1024*1024*1024), 2), ‘ GB’) AS ‘\u8868\u7a7a\u95f4’,
\nCONCAT(ROUND(INDEX_LENGTH\/(1024*1024*1024), 2), ‘ GB’) AS ‘\u7d22\u5f15\u7a7a\u95f4’,
\nCONCAT(ROUND((DATA_LENGTH+INDEX_LENGTH)\/(1024*1024*1024),2),’ GB’) AS’\u603b\u7a7a\u95f4’
\nFROM information_schema.TABLES WHERE TABLE_SCHEMA = [\u6570\u636e\u5e93\u540d] AND TABLE_NAME = [\u6570\u636e\u8868\u540d] ORDER BY TABLE_ROWS DESC;<\/p>\n","protected":false},"excerpt":{"rendered":"
https:\/\/www.cnblogs.com\/l…<\/p>\n