如下是sql语句:
SELECT TABLE_NAME as name,DATA_LENGTH+INDEX_LENGTH as len,TABLE_ROWS as rows FROM information_schema.TABLES WHERE TABLE_SCHEMA='database' AND TABLE_NAME='tablename'
如下是sql语句:
SELECT TABLE_NAME as name,DATA_LENGTH+INDEX_LENGTH as len,TABLE_ROWS as rows FROM information_schema.TABLES WHERE TABLE_SCHEMA='database' AND TABLE_NAME='tablename'