資料字典

回覆文章
yehlu
Site Admin
文章: 3245
註冊時間: 2004-04-15 17:20:21
來自: CodeCharge Support Engineer

資料字典

文章 yehlu »

https://stackoverflow.com/questions/179 ... excel-file


11
down vote
Here is a much simpler way:

From phpMyAdmin, select your database, then select the Structure tab.
Scroll down to the bottom of the list of tables.
Click on Data Dictionary.
Select all, and then copy/paste into Excel.
This method produces a report listing all tables, plus all fields within each table including the field type, if NULL is allowed, default value, links, comments, and MIME. It also lists all indexes including type, uniqueness, whether the index is packed, and index comments.
回覆文章

回到「MySQL」