Create database schema document

From LemonWiki共筆
Revision as of 11:53, 6 February 2017 by Planetoid (talk | contribs)
Jump to navigation Jump to search

Create database schema document from existing MySQL database.

Table document

Sample result of mysql query: EXPLAIN <table>

Field | Type | Null | Key | Default | Extra

sample result of mysql query: SHOW FULL COLUMNS FROM <table>

Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment

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

DDL document

Data definition language (DDL): Sample result of mysql query: SHOW CREATE TABLE <table>

CREATE TABLE `table` (
  `id` varchar(30) NOT NULL,
  `note` varchar(30) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Tools: SQL syntax beautifier

Related pages: