當前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

Mysql数据字典导出

發布時間：2025/3/14 数据库 13 豆豆

生活随笔收集整理的這篇文章主要介紹了 Mysql数据字典导出小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

1、phpmyadmin中自帶的數據字典導出

2、利用下面的腳本：

<?php /*** 生成mysql數據字典*/ header("Content-type: text/html; charset=utf-8"); //配置數據庫 $dbserver = "localhost"; $dbusername = "root"; $dbpassword = "123456"; $database = "store";//其他配置 $mysql_conn = @mysql_connect("$dbserver", "$dbusername", "$dbpassword") or die("Mysql connect is error."); mysql_select_db($database, $mysql_conn); mysql_query('SET NAMES utf8', $mysql_conn); $table_result = mysql_query('show tables', $mysql_conn);$no_show_table = array(); //不需要顯示的表 $no_show_field = array(); //不需要顯示的字段//取得所有的表名 while ($row = mysql_fetch_array($table_result)) {if (!in_array($row[0], $no_show_table)) {$tables[]['TABLE_NAME'] = $row[0];} } //替換所以表的表前綴 if (@$_GET['prefix']) {$prefix = 'czzj';foreach ($tables as $key => $val) {$tableName = $val['TABLE_NAME'];$string = explode('_', $tableName);if ($string[0] != $prefix) {$string[0] = $prefix;$newTableName = implode('_', $string);mysql_query('rename table '.$tableName.' TO '.$newTableName);}}echo "替換成功！";exit(); }//循環取得所有表的備注及表中列消息 foreach ($tables as $k=>$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 .= ' <h3>' . ($k + 1) . '、' . $v['TABLE_COMMENT'] .' （'. $v['TABLE_NAME']. '）</h3>'."\n";$html .= ' <table border="1" cellspacing="0" cellpadding="0" width="100%">'."\n";$html .= ' <tbody>'."\n";$html .= ' <tr>'."\n";$html .= ' <th>字段名</th>'."\n";$html .= ' <th>數據類型</th>'."\n";$html .= ' <th>默認值</th>'."\n";$html .= ' <th>允許非空</th>'."\n";$html .= ' <th>自動遞增</th>'."\n";$html .= ' <th>備注</th>'."\n";$html .= ' </tr>'."\n";foreach ($v['COLUMN'] as $f) {if (@!is_array($no_show_field[$v['TABLE_NAME']])) {$no_show_field[$v['TABLE_NAME']] = array();}if (!in_array($f['COLUMN_NAME'], $no_show_field[$v['TABLE_NAME']])) {$html .= ' <tr>'."\n";$html .= ' <td class="c1">' . $f['COLUMN_NAME'] . '</td>'."\n";$html .= ' <td class="c2">' . $f['COLUMN_TYPE'] . '</td>'."\n";$html .= ' <td class="c3">' . $f['COLUMN_DEFAULT'] . '</td>'."\n";$html .= ' <td class="c4">' . $f['IS_NULLABLE'] . '</td>'."\n";$html .= ' <td class="c5">' . ($f['EXTRA']=='auto_increment'?'是':' ') . '</td>'."\n";$html .= ' <td class="c6">' . $f['COLUMN_COMMENT'] . '</td>'."\n";$html .= ' </tr>'."\n";}}$html .= ' </tbody>'."\n";$html .= ' </table>'."\n"; } ?> <!doctype html> <html> <head> <meta charset="utf-8"> <title>商城管理后臺數據字典</title> <meta name="generator" content="ThinkDb V1.0" /> <meta name="author" content="科技有限公司http://www.tensent.cn" /> <meta name="copyright" content="2008-2014 Tensent Inc." /> <style> body, td, th { font-family: "微軟雅黑"; font-size: 14px; } .warp{margin:auto; width:900px;} .warp h3{margin:0px; padding:0px; line-height:30px; margin-top:10px;} table { border-collapse: collapse; border: 1px solid #CCC; background: #efefef; } table th { text-align: left; font-weight: bold; height: 26px; line-height: 26px; font-size: 14px; text-align:center; border: 1px solid #CCC; padding:5px;} table td { height: 20px; font-size: 14px; border: 1px solid #CCC; background-color: #fff; padding:5px;} .c1 { width: 120px; } .c2 { width: 120px; } .c3 { width: 150px; } .c4 { width: 80px; text-align:center;} .c5 { width: 80px; text-align:center;} .c6 { width: 270px; } </style> </head> <body> <div class="warp"><h1 style="text-align:center;">商城管理后臺數據字典</h1> <?php echo $html; ?> </div> </body> </html>

轉載于:https://www.cnblogs.com/xuhuaiqu/p/7522085.html

總結

以上是生活随笔為你收集整理的Mysql数据字典导出的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇：结对-贪吃蛇游戏-设计文档
下一篇：使用swagger实现在线api文档自动