php產生mysql資料字典

來源:互聯網
上載者:User

有時候我們拿到別人的資料庫,卻沒有資料字典,這個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 "";?>


運行後的結果:





相關文章

Beyond APAC's No.1 Cloud

19.6% IaaS Market Share in Asia Pacific - Gartner IT Service report, 2018

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。