Create database schema document: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 7: | Line 7: | ||
# Copy the table to other word processors | # Copy the table to other word processors | ||
sample result of {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} | sample result of mysql query: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} | ||
<pre> | <pre> | ||
Field | Type | Null | Key | Default | Extra | Field | Type | Null | Key | Default | Extra | ||
</pre> | </pre> | ||
sample result of {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}} | sample result of mysql query: {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}} | ||
<pre> | <pre> | ||
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | ||
Revision as of 12:31, 11 July 2016
Steps of create database schema document for MySQL
- Using phpMyAdmin
- SQL query: EXPLAIN <table> or SHOW FULL COLUMNS FROM <table>
- Click "Print view (with full texts)"
- Copy the table to other word processors
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