# jaywcjlove/mysql-tutorial architecture

> Architecture diagram of the GitHub repository jaywcjlove/mysql-tutorial, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-08). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/jaywcjlove/mysql-tutorial
- Repository: https://github.com/jaywcjlove/mysql-tutorial

## Overview

This repository is a Chinese-language beginner’s MySQL tutorial, not an application. The reader’s main path is studying the book and practicing its SQL examples; the README also highlights a short quick-start note and an Awesome MySQL resource list. Chapter titles and internal cross-links were not provided, so chapter nodes are identified by directory number and their membership links are left unverified.

Main entry points: [`README.md`](https://github.com/jaywcjlove/mysql-tutorial/blob/master/README.md) (MySQL Tutorial), [`docs/chapter1`](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter1) (Chapter 1), [`docs/chapter2`](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter2) (Chapter 2), [`docs/chapter3`](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter3) (Chapter 3)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_chapters_a["Chapters 1–5"]
  node_chapter1["Chapter 1"]
  node_chapter2["Chapter 2"]
  node_chapter3["Chapter 3"]
  node_chapter4["Chapter 4"]
  node_chapter5["Chapter 5"]
end

subgraph group_chapters_b["Chapters 6–10"]
  node_chapter6["Chapter 6"]
  node_chapter7["Chapter 7"]
  node_chapter8["Chapter 8"]
  node_chapter9["Chapter 9"]
  node_chapter10["Chapter 10"]
end

subgraph group_chapters_c["Chapters 11–17"]
  node_chapter11["Chapter 11"]
  node_chapter12["Chapter 12"]
  node_chapter13["Chapter 13"]
  node_chapter14["Chapter 14"]
  node_chapter15["Chapter 15"]
  node_chapter16["Chapter 16"]
  node_chapter17["Chapter 17"]
end

subgraph group_references["Quick References"]
  node_quickstart["21-Minute Primer"]
  node_awesome["Awesome MySQL<br/>[awesome-mysql.md]"]
  node_sql_example["SQL Example<br/>[create-table.sql]"]
end

node_reader(("Learner"))
node_book["MySQL Tutorial<br/>[README.md]"]
node_mysql[("MySQL Server")]

node_reader -->|"studies"| node_book
node_reader -->|"can skim"| node_quickstart
node_reader -->|"can consult"| node_awesome
node_book -.->|"includes"| node_chapter1
node_book -.->|"includes"| node_chapter2
node_book -.->|"includes"| node_chapter3
node_book -.->|"includes"| node_chapter4
node_book -.->|"includes"| node_chapter5
node_book -.->|"includes"| node_chapter6
node_book -.->|"includes"| node_chapter7
node_book -.->|"includes"| node_chapter8
node_book -.->|"includes"| node_chapter9
node_book -.->|"includes"| node_chapter10
node_book -.->|"includes"| node_chapter11
node_book -.->|"includes"| node_chapter12
node_book -.->|"includes"| node_chapter13
node_book -.->|"includes"| node_chapter14
node_book -.->|"includes"| node_chapter15
node_book -.->|"includes"| node_chapter16
node_book -.->|"includes"| node_chapter17
node_reader -.->|"can practice"| node_sql_example
node_reader -->|"runs examples on"| node_mysql

click node_book "https://github.com/jaywcjlove/mysql-tutorial/blob/master/README.md"
click node_chapter1 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter1"
click node_chapter2 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter2"
click node_chapter3 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter3"
click node_chapter4 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter4"
click node_chapter5 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter5"
click node_chapter6 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter6"
click node_chapter7 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter7"
click node_chapter8 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter8"
click node_chapter9 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter9"
click node_chapter10 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter10"
click node_chapter11 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter11"
click node_chapter12 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter12"
click node_chapter13 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter13"
click node_chapter14 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter14"
click node_chapter15 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter15"
click node_chapter16 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter16"
click node_chapter17 "https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter17"
click node_quickstart "https://github.com/jaywcjlove/mysql-tutorial/blob/master/docs/21-minutes-MySQL-basic-entry.md"
click node_awesome "https://github.com/jaywcjlove/mysql-tutorial/blob/master/docs/awesome-mysql.md"
click node_sql_example "https://github.com/jaywcjlove/mysql-tutorial/blob/master/examples/create-table.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_chapter1,node_chapter2,node_chapter3,node_chapter4,node_chapter5 toneBlue
class node_chapter6,node_chapter7,node_chapter8,node_chapter9,node_chapter10,node_mysql toneAmber
class node_chapter11,node_chapter12,node_chapter13,node_chapter14,node_chapter15,node_chapter16,node_chapter17 toneMint
class node_quickstart,node_awesome,node_sql_example toneRose
class node_reader toneIndigo
class node_book toneTeal
```

## Components

### Chapters 1–5

- [Chapter 1](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter1): `docs/chapter1`
- [Chapter 2](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter2): `docs/chapter2`
- [Chapter 3](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter3): `docs/chapter3`
- [Chapter 4](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter4): `docs/chapter4`
- [Chapter 5](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter5): `docs/chapter5`

### Chapters 6–10

- [Chapter 6](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter6): `docs/chapter6`
- [Chapter 7](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter7): `docs/chapter7`
- [Chapter 8](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter8): `docs/chapter8`
- [Chapter 9](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter9): `docs/chapter9`
- [Chapter 10](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter10): `docs/chapter10`

### Chapters 11–17

- [Chapter 11](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter11): `docs/chapter11`
- [Chapter 12](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter12): `docs/chapter12`
- [Chapter 13](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter13): `docs/chapter13`
- [Chapter 14](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter14): `docs/chapter14`
- [Chapter 15](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter15): `docs/chapter15`
- [Chapter 16](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter16): `docs/chapter16`
- [Chapter 17](https://github.com/jaywcjlove/mysql-tutorial/tree/master/docs/chapter17): `docs/chapter17`

### Quick References

- [21-Minute Primer](https://github.com/jaywcjlove/mysql-tutorial/blob/master/docs/21-minutes-MySQL-basic-entry.md): `docs/21-minutes-MySQL-basic-entry.md`
- [Awesome MySQL](https://github.com/jaywcjlove/mysql-tutorial/blob/master/docs/awesome-mysql.md): `docs/awesome-mysql.md`
- [SQL Example](https://github.com/jaywcjlove/mysql-tutorial/blob/master/examples/create-table.sql): `examples/create-table.sql`

### Other components

- **Learner**
- [MySQL Tutorial](https://github.com/jaywcjlove/mysql-tutorial/blob/master/README.md): `README.md`
- **MySQL Server**

## Connections

- Learner → MySQL Tutorial: studies (evidence: `README.md`)
- Learner → 21-Minute Primer: can skim (evidence: `README.md`)
- Learner → Awesome MySQL: can consult (evidence: `README.md`)
- MySQL Tutorial → Chapter 1: includes
- MySQL Tutorial → Chapter 2: includes
- MySQL Tutorial → Chapter 3: includes
- MySQL Tutorial → Chapter 4: includes
- MySQL Tutorial → Chapter 5: includes
- MySQL Tutorial → Chapter 6: includes
- MySQL Tutorial → Chapter 7: includes
- MySQL Tutorial → Chapter 8: includes
- MySQL Tutorial → Chapter 9: includes
- MySQL Tutorial → Chapter 10: includes
- MySQL Tutorial → Chapter 11: includes
- MySQL Tutorial → Chapter 12: includes
- MySQL Tutorial → Chapter 13: includes
- MySQL Tutorial → Chapter 14: includes
- MySQL Tutorial → Chapter 15: includes
- MySQL Tutorial → Chapter 16: includes
- MySQL Tutorial → Chapter 17: includes
- Learner → SQL Example: can practice
- Learner → MySQL Server: runs examples on (evidence: `README.md`)
