Create database schema document: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
|||
| Line 13: | Line 13: | ||
Steps of create database schema document for MySQL | Steps of create database schema document for MySQL | ||
# Using [https://www.phpmyadmin.net/ phpMyAdmin] | # Using web-based database management software such as: [https://www.phpmyadmin.net/ phpMyAdmin] or [https://www.adminer.org/ Adminer] | ||
# SQL query: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd | key =<nowiki>SHOW FULL COLUMNS FROM <table></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)" | # (for phpMyAdmin) Click "Print view (with full texts)" | ||
# Copy the table to other word processors | # Copy the table to other word processors | ||