mysql 怎么查看表数据量占用空间的sql

第一步

mysql>use information_schema

第二步

mysql>select data_length,index_length

->from tables where

->table_schema='DBNAME'

->and table_name = 'TABLENAME'

或者

mysql>select concat(round(sum(data_length/1024/1024),2),'MB') as data_length_MB, ->concat(round(sum(index_length/1024/1024),2),'MB') as index_length_MB

->from tables where

->table_schema='DBNAME'

->and table_name = 'TABLENAME'

if (select object_ID('tempdb..#BaseInfoFK')) >0 drop table #BaseInfoFK

select a.* into #BaseInfoFK from （select * from table）a#BaseInfoFK是临时表的名一定要加#

---