1.
想查看hx库的所有表大小,可以使用: SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES ...
2.
想查看hx库的enjoy表大小,可以使用: SELECT DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS FROM information_schema.TABLES WHERE ...