Create database schema document

From LemonWiki共筆
Revision as of 15:54, 14 January 2016 by Planetoid (talk | contribs)
Jump to navigation Jump to search

Steps of create database schema document for MySQL

  1. Using phpMyAdmin
  2. SQL query: EXPLAIN <table> or SHOW FULL COLUMNS FROM <table>
  3. Click "Print view (with full texts)"
  4. Copy the table to Word ...

sample result of EXPLAIN <table> 

Field
Type
Null
Key
Default
Extra

sample result of SHOW FULL COLUMNS FROM <table> 

Field
Type
Collation
Null
Key
Default
Extra
Privileges
Comment
Retrieved from "https://wiki.planetoid.info/index.php?title=Create_database_schema_document&oldid=16131"