java多线程    Java入门    vsftp    ftp    linux配置    centos    FRP教程    HBase    Html5缓存    webp    zabbix    分布式    neo4j图数据库    

读取mysql一个库下面的所有的表table

queryArray($sql);

//var_dump($arr);
foreach ($arr as $k => $v) {
	$tbname = $v->TABLE_NAME;
	$rows = $v->TABLE_ROWS;
	echo $tbname.' - ';
	echo $rows;
	echo '
'; } ?>

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) "BASE TABLE"
["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-15 22:27:40"
["UPDATE_TIME"]=>
string(19) "2016-12-04 11:25:55"
["CHECK_TIME"]=>
string(19) "2016-12-04 11:19:50"
["TABLE_COLLATION"]=>
string(15) "utf8_general_ci"
["CHECKSUM"]=>
NULL
["CREATE_OPTIONS"]=>
string(0) ""
["TABLE_COMMENT"]=>
string(0) ""


This entry was posted in PHP, 数据库 and tagged . Bookmark the permalink.
月小升QQ 2651044202, 技术交流QQ群 178491360
首发地址:月小升博客https://java-er.com/blog/read-mysql-table/
无特殊说明,文章均为月小升原创,欢迎转载,转载请注明本文地址,谢谢
您的评论是我写作的动力.

Leave a Reply