原始效果
--------------------------------------------------
数据库总量:
490766329
数据库大小:
25115924452
---------------------------------------------------
要达到的效果
数据库总量:
4.90亿条
数据库大小:
23.39 GB
关键代码
$e=0;
$count=mysql_query("select table_name from information_schema.tables where table_schema='data'");
while($rows=mysql_fetch_array($count)){
$c= $rows['table_name'];
$count_table=mysql_query("select count(*) from $c");
while(@$d=mysql_fetch_array($count_table)){
$e= $e+($d['count(*)']);
}
}
?>
只会用笨办法了;
$a = 490766329;$b = 25115924452;echo number_format(floor($a*pow(10, -6))*pow(10, -2),2);echo number_format($b/pow(1024,3),2).'GB';
$sql = "select sum(TABLE_ROWS) as 记录数, sum(DATA_LENGTH+INDEX_LENGTH) as 占用空间 from information_schema.tables where table_schema='data'";$rs = mysql_query($sql);print_r(mysql_fetch_assoc($rs));
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
224
收藏
