Create database schema document

From LemonWiki共筆
Revision as of 11:38, 15 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 other word processors

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