mysql統(tǒng)計一張表中條目個數的方法_MySQL

select count(*) from tableName;

#or
select count(1) from tableName;
#or 統(tǒng)計一個列項，如ID
select count(ID)

SELECT information_schema.`TABLES`.TABLE_NAME,
 (DATA_LENGTH/1024/1024) as DataM ,
 (INDEX_LENGTH/1024/1024) as IndexM, 
 ((DATA_LENGTH+INDEX_LENGTH)/1024/1024) as AllM,
 TABLE_ROWS
from information_schema.`TABLES` 
where information_schema.`TABLES`.TABLE_SCHEMA='abc';