資料字典
發表於 : 2018-10-08 14:09:11
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.
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.