Create database schema document
Jump to navigation
Jump to search
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 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