wiki:mysql

This is an old revision of the document!

MySQL

Keyword Tree (click to open each child page)

Overview (What is MySQL?)

Install & Tools (mysql, mysqld, client)

DDL (CREATE/ALTER/DROP)

DML (SELECT/INSERT/UPDATE/DELETE)

DCL (GRANT/REVOKE)

TCL (COMMIT/ROLLBACK)

Date & Time types

Schema & Table Design

Constraints (PK/FK/UNIQUE/CHECK)

Relationships (1-1, 1-N, N-N)

Composite index

Joins & Query Patterns

Transactions & Concurrency

Isolation Levels

Storage Engines

Charset & Collation (utf8mb4)

EXPLAIN & Query Optimization

Backup & Restore

Security (Users, Privileges)

Configuration (my.cnf)

Monitoring (slow log, metrics)

wiki/mysql.1768173472.txt.gz · Last modified: 2026/01/11 23:17 by phong2018