php生成mysql数据字典_php

文章目录[隐藏]

". $v["TABLE_COMMENT"] . "

有时候我们拿到别人的数据库，却没有数据字典，这个php小程序帮你轻松解决。

代码是网上找到的，当然，这段代码也仅仅是生成了数据字典，视图，存储过程等等是木有的哦。

$v) {     $sql  = "SELECT * FROM ";     $sql .= "INFORMATION_SCHEMA.TABLES ";     $sql .= "WHERE ";     $sql .= "table_name = "{$v["TABLE_NAME"]}"  AND table_schema = "{$database}"";     $table_result = mysql_query($sql, $mysql_conn);     while ($t = mysql_fetch_array($table_result) ) {         $tables[$k]["TABLE_COMMENT"] = $t["TABLE_COMMENT"];     }      $sql  = "SELECT * FROM ";     $sql .= "INFORMATION_SCHEMA.COLUMNS ";     $sql .= "WHERE ";     $sql .= "table_name = "{$v["TABLE_NAME"]}" AND table_schema = "{$database}"";      $fields = array();     $field_result = mysql_query($sql, $mysql_conn);     while ($t = mysql_fetch_array($field_result) ) {         $fields[] = $t;     }     $tables[$k]["COLUMN"] = $fields; } mysql_close($mysql_conn);   $html = ""; //循环所有表 foreach ($tables AS $k=>$v) {     //$html .= "
". $v["TABLE_COMMENT"] . "
";     $html .= "";     $html .= "";     $html .= "";     $html .= "";      foreach ($v["COLUMN"] AS $f) {         $html .= "";         $html .= "";         $html .= "";         $html .= "";         $html .= "";         $html .= "";         $html .= "";     }     $html .= "" . $v["TABLE_NAME"] ."  ". $v["TABLE_COMMENT"]. "字段名 数据类型 默认值      允许非空      自动递增 备注
" . $f["COLUMN_NAME"] . " " . $f["COLUMN_TYPE"] . "  " . $f["COLUMN_DEFAULT"] . "  " . $f["IS_NULLABLE"] . " " . ($f["EXTRA"]=="auto_increment"?"是":" ") . "  " . $f["COLUMN_COMMENT"] . "
"; }  //输出 echo "   ".$title."   "; echo "".$title."
"; echo $html; echo "";  ?>

" . $v["TABLE_NAME"] ." ". $v["TABLE_COMMENT"]. "
字段名	数据类型	默认值	允许非空	自动递增	备注
" . $f["COLUMN_NAME"] . "	" . $f["COLUMN_TYPE"] . "	" . $f["COLUMN_DEFAULT"] . "	" . $f["IS_NULLABLE"] . "	" . ($f["EXTRA"]=="auto_increment"?"是":" ") . "	" . $f["COLUMN_COMMENT"] . "

运行后的结果：

php生成mysql数据字典_php

欢迎大家阅读《php生成mysql数据字典_php》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码

搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]‍，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php生成mysql数据字典_php

". $v["TABLE_COMMENT"] . "

".$title."

Hi，您需要填写昵称和邮箱！