Create database schema document: Difference between revisions
Jump to navigation
Jump to search
(Created page with " Steps of create database schema document for MySQL # Using [https://www.phpmyadmin.net/ phpMyAdmin] # SQL query: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd | k...") |
No edit summary |
||
| Line 3: | Line 3: | ||
# Using [https://www.phpmyadmin.net/ phpMyAdmin] | # Using [https://www.phpmyadmin.net/ phpMyAdmin] | ||
# SQL query: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd | key =<nowiki> | # SQL query: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}} | ||
# Click "Print view (with full texts)" | # Click "Print view (with full texts)" | ||
# Copy the table to Word ... | # Copy the table to Word ... | ||
sample result of {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} | |||
<pre> | |||
Field | |||
Type | |||
Null | |||
Key | |||
Default | |||
Extra | |||
</pre> | |||
sample result of {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}} | |||
<pre> | |||
Field | |||
Type | |||
Collation | |||
Null | |||
Key | |||
Default | |||
Extra | |||
Privileges | |||
Comment | |||
</pre> | |||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Data Science]] | [[Category:Data Science]] | ||
Revision as of 15:54, 14 January 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 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