Create database schema document

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

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

related pages:

• Data type