读取mysql一个库下面的所有的表table
我们先来看代码:
<?php require'class/db.php'; $sql="select*frominformation_schema.tableswheretable_schema='ecshop'andtable_type='basetable'orderbyTABLE_ROWSdesc"; $arr=$db->queryArray($sql); //var_dump($arr); foreach($arras$k=>$v){ $tbname=$v->TABLE_NAME; $rows=$v->TABLE_ROWS; echo$tbname.'-'; echo$rows; echo'<br>'; } ?>
TABLE_NAME表名字
TABLE_ROWS表记录数量
DATA_LENGTH数据长度。
["TABLE_CATALOG"]=>
NULL
["TABLE_SCHEMA"]=>
string(10)“leo_ecshop”
["TABLE_NAME"]=>
string(9)“ecs_goods”
["TABLE_TYPE"]=>
string(10)“BASETABLE”
["ENGINE"]=>
string(6)“MyISAM”
["VERSION"]=>
string(2)“10″
["ROW_FORMAT"]=>
string(7)“Dynamic”
["TABLE_ROWS"]=>
string(1)“7″
["AVG_ROW_LENGTH"]=>
string(3)“286″
["DATA_LENGTH"]=>
string(4)“2008″
["MAX_DATA_LENGTH"]=>
string(15)“281474976710655″
["INDEX_LENGTH"]=>
string(5)“11264″
["DATA_FREE"]=>
string(1)“0″
["AUTO_INCREMENT"]=>
string(1)“8″
["CREATE_TIME"]=>
string(19)“2016-11-1522:27:40″
["UPDATE_TIME"]=>
string(19)“2016-12-0411:25:55″
["CHECK_TIME"]=>
string(19)“2016-12-0411:19:50″
["TABLE_COLLATION"]=>
string(15)“utf8_general_ci”
["CHECKSUM"]=>
NULL
["CREATE_OPTIONS"]=>
string(0)“”
["TABLE_COMMENT"]=>
string(0)“”